Re: Dumping functions with pg_dump

Greg Corradini <gregcorradini(at)gmail(dot)com> writes:

> Hello,
> Is it possible yet in 8.4 to pg_dump specific functions without having to do
> the whole pg_restore thing?
>
> If it is possible, what is the syntax to dump a specific function?
>
> If not possible, then how does one use pg_restore to target a specific
> function?

Just do;

pg_dump --schema-only

Go find the function definition in the output script, snip it out and
load with psql. Remember to load it into the correct schema and
whatever other details.

HTH

--
Jerry Sievers
e: gsievers19(at)comcast(dot)net
p: 305.321.1144