On Thu, Mar 30, 2017 at 1:57 PM, matshyeq <matsh...@gmail.com> wrote:
> 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? > I call anything that, is stored in the database server and has some identity, as database objects. I refer database, schema, tables, indexes, roles, tablespace, etc. (and, many more) as a database object. Nodes are the one, which are being shown on the left hand-side tree. A database object is also a node, but - not all nodes are database objects. e.g. Server Groups, Servers are nodes, but - not the database objects. NOTE: I mean only me, not pgAdmin community here. :-) -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA > > Thank you, > Kind Regards > ~Maciek > > On 30 March 2017 at 09:48, Ashesh Vashi <ashesh.va...@enterprisedb.com> > wrote: > >> On Thu, Mar 30, 2017 at 1:17 PM, Ashesh Vashi < >> ashesh.va...@enterprisedb.com> wrote: >> >>> On Thu, Mar 30, 2017 at 1:05 PM, matshyeq <matsh...@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=w >>> eb/pgadmin/browser/server_groups/servers/databases/templates >>> /databases/sql/default/create.sql;h=58b37da762c750d24a9fff96 >>> 6f4b0b7f47a56880;hb=HEAD >>> https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=blob;f=w >>> eb/pgadmin/browser/server_groups/servers/databases/templates >>> /databases/sql/default/alter_offline.sql;h=6f2b46129dfdaee88 >>> d9d7f92b829d5b306c94108;hb=HEAD >>> https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=blob;f=w >>> eb/pgadmin/browser/server_groups/servers/databases/templates >>> /databases/sql/default/alter_online.sql;h=680ab2352051ac1997 >>> 647205510cc664c41aa99b;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.zabuaw...@enterprisedb.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 <matsh...@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 >>>>>> >>>>> >>>>> >>>> >>> >> >