Re: [pgadmin-support] SQL tab - DDL syntax
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: >> 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/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 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 >> > >
Re: [pgadmin-support] SQL tab - DDL syntax
On Thu, Mar 30, 2017 at 1:05 PM, matshyeq 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 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 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 >>> >> >> >
Re: [pgadmin-support] SQL tab - DDL syntax
On Thu, Mar 30, 2017 at 1:17 PM, Ashesh Vashi wrote: > On Thu, Mar 30, 2017 at 1:05 PM, matshyeq 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 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 >>> >>> >> >
Re: [pgadmin-support] 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 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 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.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 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 > >>> >> >
Re: [pgadmin-support] SQL tab - DDL syntax
On Thu, Mar 30, 2017 at 1:57 PM, matshyeq 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 > 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 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 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 >> > > >>> >> >
Re: [pgadmin-support] Building runtime-only pgAdmin4
On Wed, Mar 29, 2017 at 8:20 PM, marcelo wrote: > Near exactly the problems I confronted. > I don't know why this complex and troublesome build process. Because it's a complex piece of software, and unless you're familiar with Python is probably going to be a daunting task to configure manually. Why are you trying to build by hand? It's really not expected that end-users do that; it should only be packagers and developers who have to do it that way. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Building runtime-only pgAdmin4
On Thu, 30 Mar 2017, Dave Page wrote: Why are you trying to build by hand? It's really not expected that end-users do that; it should only be packagers and developers who have to do it that way. While SlackBuilds.org has a working build script for pgadmin3 no one has undertaken the task of providing one for pgAdmin4. Postgres and related tools are not part of the Slackware distribution; mariadb has replaced mysql in that. So, those of us who would like to try pgAdmin4 must build piece-by-piece. I've no idea about other distributions or OSes so can write only for myself and other Slackware users. Rich -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Building runtime-only pgAdmin4
In the first place, I am a developer. So, what is the question if I try to build some software from the sources? Second: there is no pgAdmin4 binaries for Debian and derived distros. Lastly, mr Developer: some years ago, I contributed to porting Postgres 8.3 to QnX. So, it's supposed I could read source code and adapt it to a very special environment like that. On 30/03/17 10:31, Dave Page wrote: On Wed, Mar 29, 2017 at 8:20 PM, marcelo wrote: Near exactly the problems I confronted. I don't know why this complex and troublesome build process. Because it's a complex piece of software, and unless you're familiar with Python is probably going to be a daunting task to configure manually. Why are you trying to build by hand? It's really not expected that end-users do that; it should only be packagers and developers who have to do it that way. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Building runtime-only pgAdmin4
On Thu, Mar 30, 2017 at 11:55 AM, marcelo wrote: > In the first place, I am a developer. So, what is the question if I try to > build some software from the sources? > > Second: there is no pgAdmin4 binaries for Debian and derived distros. > > Lastly, mr Developer: some years ago, I contributed to porting Postgres 8.3 > to QnX. So, it's supposed I could read source code and adapt it to a very > special environment like that. There's no need for sarcasm. I have no idea of your abilities or what you are trying to achieve. Had your goal been to just run pgAdmin, then I might have been able to help you find a pre-built package to save you having to do more work. Unfortunately much I would like to have them, we do not yet have Debian packages. In the meantime, my best suggestion is to either build from source (which I realise is not straightforward), or you could download the EnterpriseDB PostgreSQL 9.6 installers from http://www.enterprisedb.com/products/pgdownload.do#linux, install them, and then shutdown and disable the database server. Those packages include a build of pgAdmin that should run on most modern Linuxes (though I honestly don't know about Slackware which Rich was trying to use). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] PgAdmin4 Bug report - Zoomed too far out
I was able to zoom back in with this shortcut key combination: shift + command + "+" To zoom out: command + "+" macOS Sierra version: 10.12.3 pgAdmin 4 version: 1.3 -- View this message in context: http://www.postgresql-archive.org/PgAdmin4-Bug-report-Zoomed-too-far-out-tp5926867p5953091.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support