Thread: Database structure and relation viewer/editor

Database structure and relation viewer/editor

From
cedricb@aeronomie.be
Date:
Dear PostgreSQL support,

I couldn't find any free tool or way to graphically view and or edit my
PostgreSQL database structure (tables and relations) like the tool
available in MS Access.

Does this exist ?
If yes, How to proceed ?

PS.: I am using PostgreSQL under Suze Linux 10.2 and use pgAdminIII to
manage it (but pgAdminIII apparently doesn't offer any graphical view of
the database structure).

Thanks in adavnace for your help

Best Regards

Cédric





Re: Database structure and relation viewer/editor

From
Melvin Davidson
Date:
Try DbDesigner 4 by FabForce

http://fabforce.net/dbdesigner4/

It's a bit kludgy, but it's free and can do reverse engineering. You will need the PostgreSQL ODBC driver to use it.

By default, it selects all schemas and tables to reverse engineer, so make sure you uncheck the ones you don't want
(pg_catalog & information_schema) and just leave one database and related schemas.

good luck,
Melvin Davidson

-----Original Message-----
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
cedricb@aeronomie.be
Sent: Monday, March 31, 2008 8:45 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Database structure and relation viewer/editor

Dear PostgreSQL support,

I couldn't find any free tool or way to graphically view and or edit my
PostgreSQL database structure (tables and relations) like the tool
available in MS Access.

Does this exist ?
If yes, How to proceed ?

PS.: I am using PostgreSQL under Suze Linux 10.2 and use pgAdminIII to
manage it (but pgAdminIII apparently doesn't offer any graphical view of
the database structure).

Thanks in adavnace for your help

Best Regards

Cédric




--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


Re: Database structure and relation viewer/editor

From
Guy Rouillier
Date:
Melvin Davidson wrote:
> Try DbDesigner 4 by FabForce
> 
> http://fabforce.net/dbdesigner4/
> 

A more recently maintained version of this tool can be found here:

https://sourceforge.net/projects/dbdesigner-fork/

-- 
Guy Rouillier