Thread: pgAdmin4 repo function diff

pgAdmin4 repo function diff

From
Дмитрий Иванов
Date:
Good afternoon. I tried to use the diff option in the following variant:
MyBase(source)->MySchema
Base(template0)->MeSchema
Got the result I'm interested in, but I'd like to try another use case. I need to upload database objects to the git directory as separate files in your "CREATE" format to evaluate the version control capabilities of the schema in this format:
pg_git->MyBase->MyShema--->Tables------>table1.sql
                                                |               |
                                                |               ----->table2.sql 
                                                |--Functions----->function1.sql
                                                                    |
                                                                    ----->function2.sql

I'm having trouble with the initial analysis of the project (repo pgadmin4), you can see that jinja templates are used, but the unloading mechanism as a whole is not clear to me. If not forbidden, can I get a general description of the unloading sequence of the schema (starting point) and an explanation of the use of templates (which ones for what) to form SQL queries and data output using CREATE templates in "Query Tool"?
--
Regards, Dmitry!