Thread: PostgreSQL Tool?
Where can i find a tool for print graphical PostgreSQL schemas?
http://www.thekompany.com/products/dataarchitect/ Is an awesome tool. The "Reverse Engineer" ability will build the model from an existing database. On Thu, 14 Oct 2004, [UTF-8] Sídar LC wrote: > 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 | spider@viovio.com [ / \ http://www.viovio.com | http://www.tikipro.org
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: =.UTF-8.B.U8OtZGFyIExD.=[slopez_pg]@ceroriesgo.co.cr.comp Cc: postgresql[pgsql-admin]@postgresql.org.comp From: Christian.Fowler[spider]@viovio.com.comp Sender: pgsql-admin-owner+m15175@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. On Thu, 14 Oct 2004, [UTF-8] S�dar LC wrote: > 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 | spider@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 majordomo@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
CHRIS HOOVER wrote: >Dataarchitect looked good to me, but it could not handle a large schema. > > > What do you consider a large schema?
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+m15178@postgresql.org.comp
Subject: Re: [ADMIN] PostgreSQL Tool?
CHRIS HOOVER wrote:
>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
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: =.UTF-8.B.U8OtZGFyIExD.=[slopez_pg]@ceroriesgo.co.cr.comp Cc: postgresql[pgsql-admin]@postgresql.org.comp From: Christian.Fowler[spider]@viovio.com.comp Sender: pgsql-admin-owner+m15175@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. On Thu, 14 Oct 2004, [UTF-8] S�dar LC wrote: > 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 | spider@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 majordomo@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