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=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.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 >>>> >>> >>> >> >
