Hi, I have set of create table statements. I need to execute them at one go instead of running individual statement to create a table. Help ! Thx
-----Original Message----- From: Timothy Perrigo [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 8:40 PM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] How to make a good documentation of a database ? Autodoc might be useful: http://www.rbt.ca/autodoc/ On Nov 18, 2004, at 8:31 AM, David Pradier wrote: > Hi ! > > I've just inherited the responsibility of a postgresql database > of roughly 480 tables and 6460 columns, mainly without constraints, > not even foreign keys. > > I'd like to make it a little more orthodox (lots and lots of > constraints, yeah !!), but I need a tool to make a documentation about > every column, at least, as some column are really vicious (like, they > are a foreign key to a table which depends on the type of another > column...). > > The best idea I could come with to do that was to maintain an output of > pgdump --shema-only, versioned with cvs, annotated with a patch, itself > versioned with cvs. > Not that bright, isn't it ? > > 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). > > Does somebody know the right way to do this ? > > Best regards, > David Pradier > > -- > [EMAIL PROTECTED] - tel: 01.46.47.21.33 - fax: 01.45.20.17.98 > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
