Обсуждение: Visualizer
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.
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-engineerexisting 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: > 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. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
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