Re: SQL tab - DDL syntax

On Thu, Mar 30, 2017 at 1:05 PM, matshyeq <matshyeq(at)gmail(dot)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 in the datable.
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(at)gmail(dot)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
>>>
>>
>>
>