Re: ER Diagram design tools (Linux)

From: Colin Fox <cfox(at)cfconsulting(dot)ca>
To: Conor McTernan <conormcternan(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ER Diagram design tools (Linux)
Date: 2008-03-07 19:44:38
Message-ID: 47D19B26.6010503@cfconsulting.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,
>
> Conor
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
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.

Regards
cf

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2008-03-07 19:59:42 Re: ER Diagram design tools (Linux)
Previous Message Scott Marlowe 2008-03-07 19:28:33 Re: Problems with 8.3