Postgres Pro
Downloads
Home   >   mailing lists

Thread: Database Diagrams.

Database Diagrams.

From
"Geoff"
Date:
Sorry if this is a question that has been answered in some form or another,
but I need to know if there is a toold of some description that will help me
get a diagram of my 7.2.1 database with the relationships. I've done various
searching on google but found nothing  ( but I may be searching with the
wrong phrase's etc ). I'm using a Win32 client to develop, but the DB runs
on a debian linux server.

TIA

Geoff




-----------------------------------------------------------------------
This message is intended only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any
action in reliance upon, this information by persons or entities other than
the intended recipient is prohibited. If you receive this message in error
please contact the sender by return e-mail and delete the message from your
computer.

Any opinions contained in this message are those of the author and are not
given or endorsed by Metalogic PLC unless otherwise clearly indicated in
this message and the authority of the author to bind Metalogic is duly
verified.

Metalogic PLC accepts no liability for any errors or omissions in the
context of this message which arise as a result of internet transmission.
-----------------------------------------------------------------------

Re: Database Diagrams.

From
Stephane Schildknecht
Date:
Le jeu 18/07/2002 à 09:47, Geoff a écrit :
> Sorry if this is a question that has been answered in some form or another,
> but I need to know if there is a toold of some description that will help me
> get a diagram of my 7.2.1 database with the relationships. I've done various
> searching on google but found nothing  ( but I may be searching with the
> wrong phrase's etc ). I'm using a Win32 client to develop, but the DB runs
> on a debian linux server.

You can try DbVisualizer :
http://www.minq.se/products/dbvis/

I think it's a godd product.

There's also dbdoc, I think...
>
>
>
> -----------------------------------------------------------------------
> This message is intended only for the person or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon, this information by persons or entities other than
> the intended recipient is prohibited. If you receive this message in error
> please contact the sender by return e-mail and delete the message from your
> computer.
>
> Any opinions contained in this message are those of the author and are not
> given or endorsed by Metalogic PLC unless otherwise clearly indicated in
> this message and the authority of the author to bind Metalogic is duly
> verified.
>
> Metalogic PLC accepts no liability for any errors or omissions in the
> context of this message which arise as a result of internet transmission.
> -----------------------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
--
 _Stéphane SCHILDKNECHT___________________________________
| AurorA-SAS 69-71, Av. Pierre Grenier 92100 BOULOGNE     |
| Tel : 01.58.17.03.20 Fax : 01.58.17.03.21               |
| mailto:sschildknecht@aurora-linux.com - ICQ : 142504394 |
| "Free Markets have taught that innovation is best when  |
|  ideas flow freely." Adam Smith                         |
|_________________________________________________________|

Re: Database Diagrams.

From
Ludwig Lim
Date:
--- Geoff <geoff@metalogicplc.com> wrote:
> Sorry if this is a question that has been answered
> in some form or another,
> but I need to know if there is a toold of some
> description that will help me
> get a diagram of my 7.2.1 database with the
> relationships.
  -- There is a tool call ERWin (by Platinum
software).You can draw you ER Diagram and the program
will automatically generate the schema based on the ER
diagram you draw. This software is not open source and
is not free.

  -- I think there are free/open source alternatives.
Try searching under the category "CASE tool", "ER
diagram", etc.

-- ludwig

__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com

Re: Database Diagrams.

From
Stefan Holzheu
Date:
>
> You can try DbVisualizer :
> http://www.minq.se/products/dbvis/
>

Does anybody know whether it is possible to visualize table dependencies
with this tool?

It worked fine with Oracle but with postgresql, DbVisualizer did not
show any reference even though there where many.

I tried org.sourceforge.jxdbcon.JXDBConDriver and org.postgresql.Driver
- no difference.


Stefan

--
-----------------------------
Dr. Stefan Holzheu
Tel.: 0921/55-5720
Fax.: 0921/55-5799
BITOeK Wiss. Sekretariat
Universitaet Bayreuth
D-95440 Bayreuth
-----------------------------

Re: Database Diagrams.

From
Stephane Schildknecht
Date:
Le jeu 18/07/2002 à 12:02, Stefan Holzheu a écrit :
> >
> > You can try DbVisualizer :
> > http://www.minq.se/products/dbvis/
> >
>
> Does anybody know whether it is possible to visualize table dependencies
> with this tool?
AFAIK, it is.
>
> It worked fine with Oracle but with postgresql, DbVisualizer did not
> show any reference even though there where many.
Are there any foreign key in your tables ?

S@S