Re: Visual data model creation / maintenance tools

From: Ben Kim <bkim(at)coe(dot)tamu(dot)edu>
To: Sam Hahn <S(at)mHahn(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Visual data model creation / maintenance tools
Date: 2005-03-10 05:32:33
Message-ID: Pine.GSO.4.10.10503092313030.1700-100000@edsun.coe.tamu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> I am interested in what people here think are good tools (free or not) for
> creating / maintaining a pg data model. A layout view for relationships is

P.S.

If you are interested in only the layout view of relationship and not
designing, a trivial, despised but useful one is M$ Access. (Sorry for the
guard-up.) You can link tables from Postgresql using odbc and manually
create relationships. It's easier to handle and print than most of the
serious tools. (In fact, I find Access better when there are some (~30)
tables.)

There's also postgresql-autodoc which is supposed to create the
relationship diagram from Postgresql database along with documentation.
The documentation is very nice, but the relationship graphic (for use with
AT&T viz package) gets kind of messed up.

www.embarcadero.com has Dbartisan which is commercial and OK.

These are what I tried myself, but I know there are many, many of ERD
tools.

Regards,

Ben Kim
Database Developer/Systems Administrator
434E Harrington Tower / College of Education
Texas A&M University

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-03-10 06:36:29 Re: template1 database
Previous Message Subbiah, Stalin 2005-03-10 01:21:05 Re: Schemas to Search_path