Re: SQL tab - DDL syntax

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

> 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 *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(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>>
>>> pgAdmin4 is open source so there is nothing to disclose :)
>>>
>>> you can refer the source code https://www.pgadmin.org/develo
>>> pment/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
>>>>
>>>
>>>
>>
>