On Wed, Mar 23, 2005 at 14:10:30 +0200, Adrianna Pinska <[EMAIL PROTECTED]> wrote: > > More specifically, I've been looking for a way to persuade postgresql > to output the create script for a single object - without much > success. It seems that pg_dump can output a dump of the entire > database schema or a dump of a single table, but not of a different > kind of object like a function or view. So at the moment it looks > like I'll have to parse the output of the psql "\d" commands into > create scripts by myself.
Note that you can use the -E option to see what queries psql uses to create its output. This might help you write the queries you need to dump function bodies. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly