Re: SQL tab - DDL syntax

On Thu, Mar 30, 2017 at 1:17 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:

On Thu, Mar 30, 2017 at 1:05 PM, matshyeq <matshyeq@gmail.com> wrote:

when pressing 'Send' I felt this is the answer I'm going to get…

fair enough

Before I try to find the right place and figure it out - could you answer that question:

 

We reverse engineer the SQL based on the existing data representing the database object in the database server**.

Each node has its own logic for reverse engineering.

Output of the reversed engineering SQL can be combination of multiple Jinja2 templates.

For the database - we have logic in the 'web/pgadmin/browser/server_groups/servers/databases', we uses different Jinja2 templates.

https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=blob;f=web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/create.sql;h=58b37da762c750d24a9fff966f4b0b7f47a56880;hb=HEAD 

https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=blob;f=web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/alter_offline.sql;h=6f2b46129dfdaee88d9d7f92b829d5b306c94108;hb=HEAD

https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=blob;f=web/pgadmin/browser/server_groups/servers/databases/templates/databases/sql/default/alter_online.sql;h=680ab2352051ac1997647205510cc664c41aa99b;hb=HEAD

Similarly - we have reverse engineering templates for each database objects.

You can find them under the database directories, and they maintain their hierarchical position in it.

Hope - this will help you to figure out, what you're looking for.

--

Thanks & Regards,

Ashesh Vashi

EnterpriseDB INDIA

>> is the logic to get what's displayed in the SQL tab custom programmed in pgAdmin or leverages some some built-in postgres DB functionality and only presents same output back?

Thank you,

Kind Regards 

~Maciek

On 30 March 2017 at 07:31, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:

pgAdmin4 is open source so there is nothing to disclose :)

you can refer the source code https://www.pgadmin.org/development/git.php 

--

Regards,

Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Mar 29, 2017 at 6:21 PM, matshyeq <matshyeq@gmail.com> wrote:

Hello,

I need to automate comparison of schemas between DBs.

I've found that pg_dump produces different order of tables etc.. so can't directly compare that

but on the other hand I see pgAdmin brings up really neat syntax (and different from pg_dump)

Could you guys disclose if the logic to get SQL for a table is custom programmed by pgAdmin or uses some some built-in postgres DB functionality and only displays it's output back?

Thank you,

Kind Regards 

~Maciek