Re: Need a DB layout gui - Mailing list pgsql-general

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

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

https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sql-workbench.eu%2FFkDisplay_png.html&amp;data=02%7C01%7CBrent.Wood%40niwa.co.nz%7C9dc698049dda43b64ddb08d6f8f4adec%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C636970127137909001&amp;sdata=GsU9%2FGJRTK%2B0l1UDKTgVAxI6hyCWPsfxO7iMZBQPzFo%3D&amp;reserved=0


--
Adrian Klaver
adrian.klaver@aklaver.com