Support PostgreSQL functions reverse engineer

[ignacioinnovo]

First of all, let me congratulate for this great project!

I want to propose the addition of reverse engineer of the PostgreSQL functions as it can be done with MSSQL with the GUI assistant.

Perhaps you have been working on that so, please, update me with the news.

I have a little repository with some code to generate functions from a defined table (https://github.com/InnovoTecnologias/PostgresqlAutogeneration) but I can write some code to do the reverse engineer.

¡Thank you in advanced!

[ErikEJ]

Start by having a look at how it is done here...

[ignacioinnovo]

@ErikEJ, thank you for your response.

I have been diving into the code and I think I should create a NpgsqlServerFunctionScaffolder implementing IFunctionScaffolder and NpgsqlServerFunctionModelFactory implementing IFunctionModelFactory under RevEng.Core.50\Functions. Is this right? Is there any documentation or could anyone point me in the right direction?

[ErikEJ]

That would work for scalar functions, which is probably a good place to start.

Does postgress support stored procedures?

[ignacioinnovo]

Yes, since version 11.

[ErikEJ]

Closing as duplicate of #697