| 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: | Whole Thread | Raw Message | 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
| 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 |