On Fri, Mar 07, 2008 at 11:44:38AM -0800, Colin Fox wrote: > Conor McTernan wrote: > > I was wondering if anyone knows of any good ER Diagram tools for > > Postgres that run on Linux. > > > > I have been using DBDesigner by FabForce for a couple of years, but > > development has stopped while MySQL workbench is being built (for > > windows only). Neither of these applications will talk to Postgres and > > I've found DBDesigner to be a bit buggy at the best of times (it's > > still quite good and better than nothing I suppose). > > > > I've been using PgAdmin3 which is great for updating/managing > > tables/view etc, but I would really like something for modelling ER > > diagrams which will talk directly to Postgres. > > > > Does anyone know of any commercial or open source software that will do this? > > > > Cheers, > > I've created an XSL stylesheet that works with graphviz to reverse > engineer an ERD from a postgres database. > > If anyone's interested, I can make this available. It works quite > well. It uses a postgres-to-xml extractor that someone wrote (I > don't know who - their name is not in the file) and then I convert > the xml to graphviz. Sounds good :) Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general