Re: SQL tab - DDL syntax

That's great help, thank you Asesh!

You make distinction between nodes and database objects and there are
separate templates for each set - could you clarify the difference between
those (nodes/db objects) please?

Thank you,
Kind Regards
~Maciek

On 30 March 2017 at 09:48, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
wrote:

> 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/template
>> s/databases/sql/default/create.sql;h=58b37da762c750d24
>> a9fff966f4b0b7f47a56880;hb=HEAD
>> https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=blob;f=
>> web/pgadmin/browser/server_groups/servers/databases/template
>> s/databases/sql/default/alter_offline.sql;h=6f2b46129dfdaee8
>> 8d9d7f92b829d5b306c94108;hb=HEAD
>> https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=blob;f=
>> web/pgadmin/browser/server_groups/servers/databases/template
>> s/databases/sql/default/alter_online.sql;h=680ab2352051ac199
>> 7647205510cc664c41aa99b;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
>>>>>
>>>>
>>>>
>>>
>>
>