Visualizer

Mohammad Ali Darvish Darab, 05.11.2008 13:18:

Hello everybody,

I have got an already existing Porstgres DB which is pretty large
(including more than 650 table with considerable number of constraints
etc). And now I am supposed to realize generally how it is constructed
and works. I thought it would be good to have a grapahical
visualization of whole DB (with tables and relations etc). Does anyone
have any idea about any tool that does this? I would also appreciate
any comments or suggestions that might help me in this regard.

Thank you in advance,
Ali.

I have made good experience using Power*Architect which is an (Java based) OpenSource ER-Tool that an also reverse-engineer existing databases (that have a JDBC driver).

I have not used it with so many tables though.

You can download it from here: http://www.sqlpower.ca/page/architect

Thomas

DbVisualizer is a tool I have used in the past for exactly this.

// Matthias

On Wed, Nov 5, 2008 at 1:18 PM, Mohammad Ali Darvish Darab
<darvishdarab@gmail.com> wrote:

Mohammad Ali Darvish Darab wrote:

I have got an already existing Porstgres DB which is pretty large
(including more than 650 table with considerable number of constraints
etc). And now I am supposed to realize generally how it is constructed
and works. I thought it would be good to have a grapahical
visualization of whole DB (with tables and relations etc). Does anyone
have any idea about any tool that does this? I would also appreciate
any comments or suggestions that might help me in this regard.

I'd go for pgAdmin III, but I also have good experiences with DbVisualizer.

Yours,
Laurenz Albe