Need a DB layout gui
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?
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/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
I use Valentina Studio these days...
https://www.valentina-db.com/en/get-free-valentina-studio
Brent Wood
Programme leader: Environmental Information Delivery
NIWA
DDI: +64 (4) 3860529
[cid:image0a50e7.PNG@cb42a178.41b47e97]<http://www.niwa.co.nz>
Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
T +64-4-386-0529
National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade, Greta Point, Wellington
Connect with NIWA: niwa.co.nz<https://www.niwa.co.nz> Facebook<https://www.facebook.com/nzniwa> Twitter<https://twitter.com/niwa_nz> LinkedIn<https://www.linkedin.com/company/niwa> Instagram<https://www.instagram.com/niwa_science>
To ensure compliance with legal requirements and to maintain cyber security standards, NIWA's IT systems are subject to ongoing monitoring, activity logging and auditing. This monitoring and auditing service may be provided by third parties. Such third parties can access information transmitted to, processed by and stored on NIWA's IT systems.
________________________________________
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&amp;data=02%7C01%7CBrent.Wood%40niwa.co.nz%7C9dc698049dda43b64ddb08d6f8f4adec%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C636970127137909001&amp;sdata=rpquqXVkI4Btn%2FYXn56eW3WVEe9krM0TLlh2cJV5BhU%3D&amp;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:
--
Adrian Klaver
adrian.klaver@aklaver.com
Attachments:
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:
Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | 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 you must 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 Manifest Voting 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]http://www.pgmodeler.io/? 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.
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 DBsZ
-----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 guiI'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
Attachments:
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
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.
All very good ideas. Thanks to all for the input.
I think I'm leaning toward DBeaver. But they're all good.
Thanks !
On Tue, Jun 25, 2019 at 5:02 PM Kevin Brannen <KBrannen@efji.com> wrote:
Show quoted text
*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
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.