> 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