> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
