On Wed, Mar 23, 2005 at 14:10:30 +0200,
Adrianna Pinska <adrianna(dot)pinska(at)gmail(dot)com> 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.