Database diagram

Discussion:

Database diagram

(too old to reply)

Ganesan Kanavathy

2004-01-20 06:38:12 UTC

I have a postgres database with many tables.

How do I create database diagram? Are there any free tools available to
create database diagram from pgsql database?

Regards,
Ganesan

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Jodi Kanter

2004-01-20 13:44:34 UTC

Permalink

I use Microsoft Visio. It also has reverse engineering. I ma having
trouble with the refresh option which is quite frustrating but other
than that it works fine. I used Erwin in the past and really like that
but it is pricey and we already had a license available for Visio.
Jodi

Post by Ganesan Kanavathy
I have a postgres database with many tables.
How do I create database diagram? Are there any free tools available to
create database diagram from pgsql database?
Regards,
Ganesan
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

--
/_______________________________
//Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
***@virginia.edu <mailto:***@virginia.edu>/

/ /

/ /

Gary Stainburn

2004-01-26 10:50:48 UTC

Permalink

Dear Ganesan,
pgautodoc (for dot output) + dot (from graphviz.org , creates
postscript) +
epssplit ( splits the postscript into multipage so that one can create
poster size
diagrams) works well for me.
I have 45 tables in the database though.

Can anyone point me to a download for pgautodoc. I had a look on freshmeat
(as Chris suggested) and couldn't find it. The only other thing I could find
were RPMS that wouldn't go on my system.

Gary

Regds
mallah.

There is a free Perl script which is called something like pgautodoc which
creates DIA diagrams from databases. Take a look for it on Freshmeat.
----- Original Message -----

[snip]
--
Gary Stainburn

This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

Chris Travers

2004-01-26 11:02:59 UTC

Permalink

Sorry, it is called postgresql_autodoc. It can be found at
http://freshmeat.net/projects/postgresql_autodoc, iirc.

I have been having trouble with it crashing (segfault) which is surprising
since it is written in Perl (must be a bum CPAN module, but I will have to
wait to figure out which one).

Best Wishes,
Chris Travers

----- Original Message -----
From: "Gary Stainburn" <***@ringways.co.uk>
To: <pgsql-***@postgresql.org>
Sent: Monday, January 26, 2004 5:50 PM
Subject: Re: [ADMIN] [SQL] Database diagram

Can anyone point me to a download for pgautodoc. I had a look on freshmeat
(as Chris suggested) and couldn't find it. The only other thing I could find
were RPMS that wouldn't go on my system.

Gary

Regds
mallah.

There is a free Perl script which is called something like pgautodoc which
creates DIA diagrams from databases. Take a look for it on Freshmeat.
----- Original Message -----

Robert Creager

2004-01-26 12:28:59 UTC

Permalink

When grilled further on (Mon, 26 Jan 2004 18:02:59 +0700),

Post by Chris Travers
I have been having trouble with it crashing (segfault) which is surprising
since it is written in Perl (must be a bum CPAN module, but I will have to
wait to figure out which one).

Just wondering which version of DBD::Pg you are using? When I upgrade from 1.22
to 1.31 (DBI 1.37), Perl was segfaulting
(http://gborg.postgresql.org/project/dbdpg/bugs/bugupdate.php?628) for me when
using fetch with bind_columns.

GBorg developers cannot seem to reproduce the problem, and I have not had the
time to try and bake a simple reproduction. They got back to me 1 1/2 months
later, and still closed the bug. Kind of like the EDS crew which 'manages' our
computer systems at work :-(

Cheers,
Rob

--
05:15:30 up 28 days, 19:01, 4 users, load average: 2.00, 2.02, 2.00

Chris Travers

2004-01-26 13:17:57 UTC

Permalink

Hi Robert;

I am using DBD::Pg 1.31. That may be the problem. Any suggestions
regarding repairing this problem at the moment?

Best Wishes,
Chris Travers
----- Original Message -----
From: "Robert Creager" <***@LogicalChaos.org>
To: "Chris Travers" <***@travelamericas.com>; <pgsql-***@postgresql.org>
Sent: Monday, January 26, 2004 7:28 PM
Subject: Re: [ADMIN] [SQL] Database diagram

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

Robert Creager

2004-01-27 03:23:38 UTC

Permalink

Hey Chris,

I just installed version 1.22 from cpan and it fixed the problem. From a CPAN
prompt (if you use it) <install D/DW/DWHEELER/DBD-Pg-1.22.tar.gz>.

Cheers,
Rob

When grilled further on (Mon, 26 Jan 2004 20:17:57 +0700),

Post by Chris Travers
I am using DBD::Pg 1.31. That may be the problem. Any suggestions
regarding repairing this problem at the moment?

--
20:17:03 up 29 days, 10:02, 4 users, load average: 1.01, 1.06, 1.01