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
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 |