Thread: 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

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