Обсуждение: Need a DB layout gui
On 6/24/19 3:25 PM, David Gauthier wrote: > Hi: > > I've been poking around > https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to > see if there is anything that can read PG metadata in and display it > graphically in a gui. You know, the kind of picture that is 1 block per > table with 1->many arrows connecting up the primary/foreign keys of > different tables. SQL Power Architect looked promising, but fails to do > the linkage for some PK-FK relationships (buggy?) . > > Any suggestions on what might do this? Schemaspy: http://schemaspy.org/ http://schemaspy.org/sample/relationships.html -- Adrian Klaver adrian.klaver@aklaver.com
On Mon, 24 Jun 2019, David Gauthier wrote: > I've been poking around > https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools > to see if there is anything that can read PG metadata in and display it > graphically in a gui. You know, the kind of picture that is 1 block per > table with 1->many arrows connecting up the primary/foreign keys of > different tables. SQL Power Architect looked promising, but fails to do > the linkage for some PK-FK relationships (buggy?) . > > Any suggestions on what might do this? Looks like you want a ER (entity relationship) diagrammer. Take a look at dbeaver <http://dbeaver.jkiss.org/>. Rich
On 6/24/19 3:25 PM, David Gauthier wrote: > Hi: > > I've been poking around > https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to > see if there is anything that can read PG metadata in and display it > graphically in a gui. You know, the kind of picture that is 1 block per > table with 1->many arrows connecting up the primary/foreign keys of > different tables. SQL Power Architect looked promising, but fails to do > the linkage for some PK-FK relationships (buggy?) . > > Any suggestions on what might do this? After my previous post I realized you said GUI:( Do you want something that you can interact with? Also SQL Workbench/J will display FK relationships: http://www.sql-workbench.eu/FkDisplay_png.html -- Adrian Klaver adrian.klaver@aklaver.com
https://www.valentina-db.com/en/get-free-valentina-studio
Brent Wood
Programme leader: Environmental Information Delivery
NIWA
DDI: +64 (4) 3860529
|
|
From: Adrian Klaver <adrian.klaver@aklaver.com>
Sent: Tuesday, June 25, 2019 10:38
To: David Gauthier; pgsql-general@postgresql.org
Subject: Re: Need a DB layout gui
On 6/24/19 3:25 PM, David Gauthier wrote:
> Hi:
>
> I've been poking around
> https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.postgresql.org%2Fwiki%2FCommunity_Guide_to_PostgreSQL_GUI_Tools&data=02%7C01%7CBrent.Wood%40niwa.co.nz%7C9dc698049dda43b64ddb08d6f8f4adec%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C636970127137909001&sdata=rpquqXVkI4Btn%2FYXn56eW3WVEe9krM0TLlh2cJV5BhU%3D&reserved=0 to
> see if there is anything that can read PG metadata in and display it
> graphically in a gui. You know, the kind of picture that is 1 block per
> table with 1->many arrows connecting up the primary/foreign keys of
> different tables. SQL Power Architect looked promising, but fails to do
> the linkage for some PK-FK relationships (buggy?) .
>
> Any suggestions on what might do this?
After my previous post I realized you said GUI:(
Do you want something that you can interact with?
Also SQL Workbench/J will display FK relationships:
https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sql-workbench.eu%2FFkDisplay_png.html&data=02%7C01%7CBrent.Wood%40niwa.co.nz%7C9dc698049dda43b64ddb08d6f8f4adec%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C636970127137909001&sdata=GsU9%2FGJRTK%2B0l1UDKTgVAxI6hyCWPsfxO7iMZBQPzFo%3D&reserved=0
--
Adrian Klaver
adrian.klaver@aklaver.com
Вложения
I've been enjoying dbeaver for this Tim Clarke IT Director Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420 On 24/06/2019 23:38, Adrian Klaver wrote: > On 6/24/19 3:25 PM, David Gauthier wrote: >> Hi: >> >> I've been poking around >> https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to >> see if there is anything that can read PG metadata in and display it >> graphically in a gui. You know, the kind of picture that is 1 block >> per table with 1->many arrows connecting up the primary/foreign keys >> of different tables. SQL Power Architect looked promising, but fails >> to do the linkage for some PK-FK relationships (buggy?) . >> >> Any suggestions on what might do this? > > After my previous post I realized you said GUI:( > > Do you want something that you can interact with? > > Also SQL Workbench/J will display FK relationships: > > http://www.sql-workbench.eu/FkDisplay_png.html > > Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 58031687 | Toronto: +1 647 503 2848 Web: https://www.manifest.co.uk/ Minerva Analytics Ltd - A Solactive Company 9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom ________________________________ Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee youmust not use or disclose such information, instead please report it to admin@minerva.info<mailto:admin@minerva.info> Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The ManifestVoting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/for further information.
Hello! On 25/06/2019 00:25, David Gauthier wrote: > I've been poking > around https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to > see if there is anything that can read PG metadata in and display it > graphically in a gui. You know, the kind of picture that is 1 block per > table with 1->many arrows connecting up the primary/foreign keys of > different tables. SQL Power Architect looked promising, but fails to do > the linkage for some PK-FK relationships (buggy?) . > > Any suggestions on what might do this? Have you tried pgModeler[1]? The current limitation is that stable version works only up to PostgreSQL 10, as far as I know. But it is actively maintained, and I guess that support for PostgreSQL 11/12 is available in the beta build, which means it will be available soon. [1]: http://www.pgmodeler.io/ Cheers, Jakub Olczyk
Navicat - its costs money but always found it very useful for managing various DBs Z -----Original Message----- From: Tim Clarke <tim.clarke@minerva.info> Sent: 24 June 2019 23:56 To: pgsql-general@lists.postgresql.org Subject: Re: Need a DB layout gui I've been enjoying dbeaver for this
You also could try out DBVisualizer (https://www.dbvis.com/). It is available in a feature reduced free version. Feautre comaprison is at https://www.dbvis.com/features/feature-list/. I personally bought the pro to support development. I rarely use a pro feature. Quoting Zahir Lalani <ZahirLalani@oliver.agency>: > Navicat - its costs money but always found it very useful for > managing various DBs > > Z > -----Original Message----- > From: Tim Clarke <tim.clarke@minerva.info> > Sent: 24 June 2019 23:56 > To: pgsql-general@lists.postgresql.org > Subject: Re: Need a DB layout gui > > I've been enjoying dbeaver for this -- S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH Signal (Safer than WhatsApp): +49 1578 7723737 Handys: +41 78 947 36 21 | +49 1578 772 37 37 Tox-Id: B7282A9E31D944DDAD1ECC5B33C36AAE80B32D119AB7391D602C937A65E8CA0625C495C5322B
Вложения
From: David Gauthier <davegauthierpg@gmail.com>
> I've been poking around https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to see if there is anything that can read PG metadata in and display it graphically in a gui. You know, the kind of picture that is 1 block per table with 1->many arrows connecting up the primary/foreign keys of different tables. SQL Power Architect looked promising, but fails to do the linkage for some PK-FK relationships (buggy?) . Any suggestions on what might do this?
I use and like dbWrench; it’s written in Java so can run on Linux/Windows/Mac. It’s commercial but not expensive.
Kevin
I think I'm leaning toward DBeaver. But they're all good.
This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.From: David Gauthier <davegauthierpg@gmail.com>
> I've been poking around https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to see if there is anything that can read PG metadata in and display it graphically in a gui. You know, the kind of picture that is 1 block per table with 1->many arrows connecting up the primary/foreign keys of different tables. SQL Power Architect looked promising, but fails to do the linkage for some PK-FK relationships (buggy?) . Any suggestions on what might do this?
I use and like dbWrench; it’s written in Java so can run on Linux/Windows/Mac. It’s commercial but not expensive.
Kevin