On Thu, Nov 18, 2004 at 03:02:59PM +0000, Matt wrote: > > The problem is, I don't want to use a lot of time to maintain this > > documentation, and above all, I'd prefer not to insert the information > > twice (read: a new constraint in the database should automagically > > update the documentation). > > It's a while since I've used them (just coming back to postgres after > enforced exile in mysqlville) but last I checked: > http://gborg.postgresql.org/project/dbutils/ > Could generate UML diagrams from your DB. You might still be stuck > diff-ing them when you change the db, but at least they're prettier than > pg-dump. Thanks for the link, it's interesting :-) Not totaly perfect, still : I'll have to modify the schema of the database a lot during the next months, so I'd prefer not to have to do a lots of diffing between the database description and the 'comments documentation'. Maybe the perfect solution doesn't exist yet ? -- dpradier@xxxxxxxxxx - tel: 01.46.47.21.33 - fax: 01.45.20.17.98 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly