Re: Dumping functions with pg_dump

On Tuesday, April 05, 2011 4:19:56 pm Raymond O'Donnell wrote:
> On 06/04/2011 00:15, Greg Corradini wrote:
> > Hello,
> > Is it possible yet in 8.4 to pg_dump specific functions without having
> > to do the whole pg_restore thing?
>
> If I understand correctly what you're trying to do, a handy alternative
> is to use pgAdmin, right click on the function in the tree view, and
> select Scripts -> Create.
>
> Ray.

In addition, from inside psql do \ef function_name. This opens the function in
an editor from which you can save it elsewhere.
If you are talking a lot of functions then you can use the -l and -L options to
pg_restore to create a TOC list that can be edited to contain only the functions
you want. These than can either be restored to a database or file.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com