Discussion:
PostgreSQL Tool?
(too old to reply)
Sídar LC
2004-10-14 15:29:04 UTC
Permalink
Where can i find a tool for print graphical PostgreSQL schemas?


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Christian Fowler
2004-10-14 15:42:55 UTC
Permalink
http://www.thekompany.com/products/dataarchitect/

Is an awesome tool. The "Reverse Engineer" ability will build the model
from an existing database.
Post by Sídar LC
Where can i find a tool for print graphical PostgreSQL schemas?
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
[ \ /
[ >X< Christian Fowler | ***@viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---------------------------(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 HOOVER
2004-10-14 17:42:00 UTC
Permalink
Dataarchitect looked good to me, but it could not handle a large schema.

We are using EMS's PG Manager tool. Good for DBA'n and generating erds.
(http://ems-hitech.com/pgmanager/). Only downside is for erd's, you have to
use the windows version, not the linux version.

HTH,

Chris
------------------( Forwarded letter 1 follows )---------------------
Date: Thu, 14 Oct 2004 11:42:55 -0400 (EDT)
To: =3D.UTF-8.B.U8OtZGFyIExD.=3D[slopez_pg]@ceroriesgo.co.cr.comp
Cc: postgresql[pgsql-admin]@postgresql.org.comp
From: Christian.Fowler[spider]@viovio.com.comp
Sender: pgsql-admin-owner+***@postgresql.org.comp
Subject: Re: [ADMIN] PostgreSQL Tool?



http://www.thekompany.com/products/dataarchitect/

Is an awesome tool. The "Reverse Engineer" ability will build the model
from an existing database.
Post by Sídar LC
Where can i find a tool for print graphical PostgreSQL schemas?
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
[ \ /
[ >X< Christian Fowler | ***@viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---------------------------(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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
Michael Long
2004-10-14 18:11:59 UTC
Permalink
Post by CHRIS HOOVER
Dataarchitect looked good to me, but it could not handle a large schema.
What do you consider a large schema?

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
CHRIS HOOVER
2004-10-14 19:46:00 UTC
Permalink
We have over 100 tables in our database (some with a large number of columns -
100+), and that triggered a problem in Dataarchitect to where it would not
display the erd. All we got was a black screen. I contacted them and sent
them information, but have never heard back.

It is quite a shame since I would love to use a native linux tool.

Chris
------------------( Forwarded letter 1 follows )---------------------
Date: Thu, 14 Oct 2004 14:11:59 -0400
Cc: postgresql[pgsql-admin]@postgresql.org.comp
From: Michael.Long[mlong]@datalong.com.comp
Sender: pgsql-admin-owner+***@postgresql.org.comp
Subject: Re: [ADMIN] PostgreSQL Tool?
Post by CHRIS HOOVER
Dataarchitect looked good to me, but it could not handle a large schema.
What do you consider a large schema?

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)
Loading...