pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase diagram
14+ messages / 11 participants
[nested] [flat]
* Database diagram
@ 2004-01-20 06:38 Ganesan Kanavathy <ganesh@magnusquest.com>
0 siblings, 5 replies; 14+ messages in thread
From: Ganesan Kanavathy @ 2004-01-20 06:38 UTC (permalink / raw)
To: pgsql-admin@postgresql.org; pgsql-sql
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
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Database diagram
@ 2004-01-20 07:01 Denis <sqllist@coralindia.com>
parent: Ganesan Kanavathy <ganesh@magnusquest.com>
4 siblings, 0 replies; 14+ messages in thread
From: Denis @ 2004-01-20 07:01 UTC (permalink / raw)
To: pgsql-sql
Hi Ganesan,
You can try ERWin (by CA).
It creates Logical data model of the database. (though.. i haven't used
it..)
HTH
Thanx
Denis
----- Original Message -----
From: "Ganesan Kanavathy" <ganesh@magnusquest.com>
To: <pgsql-admin@postgresql.org>; <pgsql-sql@postgresql.org>
Sent: Tuesday, January 20, 2004 12:08 PM
Subject: [SQL] Database diagram
> 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 8: explain analyze is your friend
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Database diagram
@ 2004-01-20 07:17 Roberto Mello <rmello@cc.usu.edu>
parent: Ganesan Kanavathy <ganesh@magnusquest.com>
4 siblings, 0 replies; 14+ messages in thread
From: Roberto Mello @ 2004-01-20 07:17 UTC (permalink / raw)
To: Ganesan Kanavathy <ganesh@magnusquest.com>; +Cc: pgsql-admin@postgresql.org; pgsql-sql
On Tue, Jan 20, 2004 at 02:38:12PM +0800, Ganesan Kanavathy wrote:
> 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?
There are several such tools:
http://www.rbt.ca/autodoc/
dbVisualizer - gratis, but not Free
and many others. Search in freshmeat.net and google.
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net/ |------+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
Veni, Vidi, VCR - I came, I saw, I videotaped it
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Database diagram
@ 2004-01-20 07:35 Gregory S. Williamson <gsw@globexplorer.com>
0 siblings, 0 replies; 14+ messages in thread
From: Gregory S. Williamson @ 2004-01-20 07:35 UTC (permalink / raw)
To: Denis <sqllist@coralindia.com>; pgsql-sql
ERWin is likely to be expensive, judging by the cost for an Informix license. It is also a serious tool; has its quirks but can be used to reverse engineer as well as define a database with detailed support for triggers and the like.
Greg Williamson
DBA
GlobeXplorer LLC
-----Original Message-----
From: Denis [mailto:sqllist@coralindia.com]
Sent: Mon 1/19/2004 11:01 PM
To: pgsql-sql@postgresql.org
Cc:
Subject: Re: [SQL] Database diagram
Hi Ganesan,
You can try ERWin (by CA).
It creates Logical data model of the database. (though.. i haven't used
it..)
HTH
Thanx
Denis
----- Original Message -----
From: "Ganesan Kanavathy" <ganesh@magnusquest.com>
To: <pgsql-admin@postgresql.org>; <pgsql-sql@postgresql.org>
Sent: Tuesday, January 20, 2004 12:08 PM
Subject: [SQL] Database diagram
> 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 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Database diagram
@ 2004-01-20 13:44 Jodi Kanter <jkanter@virginia.edu>
parent: Ganesan Kanavathy <ganesh@magnusquest.com>
4 siblings, 0 replies; 14+ messages in thread
From: Jodi Kanter @ 2004-01-20 13:44 UTC (permalink / raw)
To: Ganesan Kanavathy <ganesh@magnusquest.com>; +Cc: pgsql-admin@postgresql.org
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
Ganesan Kanavathy wrote:
>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
jkanter@virginia.edu <mailto:jkanter@virginia.edu>/
/ /
/ /
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Database diagram
@ 2004-01-20 14:30 Luis Sousa <llsousa@ualg.pt>
parent: Ganesan Kanavathy <ganesh@magnusquest.com>
4 siblings, 0 replies; 14+ messages in thread
From: Luis Sousa @ 2004-01-20 14:30 UTC (permalink / raw)
To: Ganesan Kanavathy <ganesh@magnusquest.com>; +Cc: pgsql-admin@postgresql.org; pgsql-sql
Ganesan Kanavathy wrote:
>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 8: explain analyze is your friend
>
>
>
>
Did you already tried dia?
I never used it, but someone told me that imports data definition from
PostgreSQL. You can try it.
Luis Sousa
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.5K) download
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Database diagram
@ 2004-01-22 08:38 Chris Travers <chris@travelamericas.com>
parent: Ganesan Kanavathy <ganesh@magnusquest.com>
4 siblings, 2 replies; 14+ messages in thread
From: Chris Travers @ 2004-01-22 08:38 UTC (permalink / raw)
To: Ganesan Kanavathy <ganesh@magnusquest.com>; pgsql-admin@postgresql.org; pgsql-sql
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 -----
From: "Ganesan Kanavathy" <ganesh@magnusquest.com>
To: <pgsql-admin@postgresql.org>; <pgsql-sql@postgresql.org>
Sent: Tuesday, January 20, 2004 1:38 PM
Subject: [SQL] Database diagram
> 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 8: explain analyze is your friend
>
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Database diagram
@ 2004-01-22 16:31 Rita Rossinelli-Biagioni <Rita@ares.com>
parent: Chris Travers <chris@travelamericas.com>
1 sibling, 0 replies; 14+ messages in thread
From: Rita Rossinelli-Biagioni @ 2004-01-22 16:31 UTC (permalink / raw)
To: Chris Travers <chris@travelamericas.com>; +Cc: Ganesan Kanavathy <ganesh@magnusquest.com>; pgsql-admin@postgresql.org; pgsql-sql
http://freshmeat.net/projects/postgresql_autodoc/?topic_id=66
Postgresql AutoDoc - Default branch
by Rod Taylor - Thursday, July 19th 2001 11:15 PST Section: Software
About:
Postgresql AutoDoc has the ability to output XML, which can be loaded
into Dia to create a UML diagram of the database (complete with table
relations and descriptive information), an HTML form for further
detailed information, GraphViz .dot output, and Docbook 4.1 style SGML
for inclusion with project documentation as an appendix. It works on any
7.x PostgreSQL-based database.
Chris Travers wrote:
> 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 -----
> From: "Ganesan Kanavathy" <ganesh@magnusquest.com>
> To: <pgsql-admin@postgresql.org>; <pgsql-sql@postgresql.org>
> Sent: Tuesday, January 20, 2004 1:38 PM
> Subject: [SQL] Database diagram
>
>
>
>>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 8: explain analyze is your friend
>>
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Database diagram
@ 2004-01-23 18:16 Rajesh Kumar Mallah <mallah@trade-india.com>
parent: Chris Travers <chris@travelamericas.com>
1 sibling, 1 reply; 14+ messages in thread
From: Rajesh Kumar Mallah @ 2004-01-23 18:16 UTC (permalink / raw)
To: Chris Travers <chris@travelamericas.com>; +Cc: Ganesan Kanavathy <ganesh@magnusquest.com>; pgsql-admin@postgresql.org; pgsql-sql
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.
Regds
mallah.
Chris Travers wrote:
>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 -----
>From: "Ganesan Kanavathy" <ganesh@magnusquest.com>
>To: <pgsql-admin@postgresql.org>; <pgsql-sql@postgresql.org>
>Sent: Tuesday, January 20, 2004 1:38 PM
>Subject: [SQL] Database diagram
>
>
>
>
>>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 8: explain analyze is your friend
>>
>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Database diagram
@ 2004-01-26 10:50 Gary Stainburn <gary.stainburn@ringways.co.uk>
parent: Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 1 reply; 14+ messages in thread
From: Gary Stainburn @ 2004-01-26 10:50 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
On Friday 23 January 2004 6:16 pm, Rajesh Kumar Mallah wrote:
> 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.
>
> Chris Travers wrote:
> >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
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Database diagram
@ 2004-01-26 11:02 Chris Travers <chris@travelamericas.com>
parent: Gary Stainburn <gary.stainburn@ringways.co.uk>
0 siblings, 1 reply; 14+ messages in thread
From: Chris Travers @ 2004-01-26 11:02 UTC (permalink / raw)
To: Gary Stainburn <gary.stainburn@ringways.co.uk>; pgsql-admin@postgresql.org
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" <gary.stainburn@ringways.co.uk>
To: <pgsql-admin@postgresql.org>
Sent: Monday, January 26, 2004 5:50 PM
Subject: Re: [ADMIN] [SQL] Database diagram
On Friday 23 January 2004 6:16 pm, Rajesh Kumar Mallah wrote:
> 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.
>
> Chris Travers wrote:
> >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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Database diagram
@ 2004-01-26 12:28 Robert Creager <Robert_Creager@LogicalChaos.org>
parent: Chris Travers <chris@travelamericas.com>
0 siblings, 1 reply; 14+ messages in thread
From: Robert Creager @ 2004-01-26 12:28 UTC (permalink / raw)
To: Chris Travers <chris@travelamericas.com>; pgsql-admin@postgresql.org
When grilled further on (Mon, 26 Jan 2004 18:02:59 +0700),
"Chris Travers" <chris@travelamericas.com> confessed:
> 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
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Database diagram
@ 2004-01-26 13:17 Chris Travers <chris@travelamericas.com>
parent: Robert Creager <Robert_Creager@LogicalChaos.org>
0 siblings, 1 reply; 14+ messages in thread
From: Chris Travers @ 2004-01-26 13:17 UTC (permalink / raw)
To: Robert Creager <Robert_Creager@LogicalChaos.org>; pgsql-admin@postgresql.org
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" <Robert_Creager@LogicalChaos.org>
To: "Chris Travers" <chris@travelamericas.com>; <pgsql-admin@postgresql.org>
Sent: Monday, January 26, 2004 7:28 PM
Subject: Re: [ADMIN] [SQL] Database diagram
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [SQL] Database diagram
@ 2004-01-27 03:23 Robert Creager <Robert_Creager@LogicalChaos.org>
parent: Chris Travers <chris@travelamericas.com>
0 siblings, 0 replies; 14+ messages in thread
From: Robert Creager @ 2004-01-27 03:23 UTC (permalink / raw)
To: Chris Travers <chris@travelamericas.com>; +Cc: pgsql-admin@postgresql.org
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),
"Chris Travers" <chris@travelamericas.com> confessed:
> 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
^ permalink raw reply [nested|flat] 14+ messages in thread
end of thread, other threads:[~2004-01-27 03:23 UTC | newest]
Thread overview: 14+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-20 06:38 Database diagram Ganesan Kanavathy <ganesh@magnusquest.com>
2004-01-20 07:01 ` Denis <sqllist@coralindia.com>
2004-01-20 07:17 ` Roberto Mello <rmello@cc.usu.edu>
2004-01-20 13:44 ` Jodi Kanter <jkanter@virginia.edu>
2004-01-20 14:30 ` Luis Sousa <llsousa@ualg.pt>
2004-01-22 08:38 ` Chris Travers <chris@travelamericas.com>
2004-01-22 16:31 ` Rita Rossinelli-Biagioni <Rita@ares.com>
2004-01-23 18:16 ` Rajesh Kumar Mallah <mallah@trade-india.com>
2004-01-26 10:50 ` Gary Stainburn <gary.stainburn@ringways.co.uk>
2004-01-26 11:02 ` Chris Travers <chris@travelamericas.com>
2004-01-26 12:28 ` Robert Creager <Robert_Creager@LogicalChaos.org>
2004-01-26 13:17 ` Chris Travers <chris@travelamericas.com>
2004-01-27 03:23 ` Robert Creager <Robert_Creager@LogicalChaos.org>
2004-01-20 07:35 Re: Database diagram Gregory S. Williamson <gsw@globexplorer.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox