Re: Dumping functions with pg_dump - Mailing list pgsql-general

From Jerry Sievers
Subject Re: Dumping functions with pg_dump
Date
Msg-id 87ipusz394.fsf@comcast.net
Whole thread Raw
In response to Dumping functions with pg_dump  (Greg Corradini <gregcorradini@gmail.com>)
List pgsql-general
Greg Corradini <gregcorradini@gmail.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@comcast.net
p: 305.321.1144

pgsql-general by date:

Previous
From: Greg Corradini
Date:
Subject: Re: Dumping functions with pg_dump
Next
From: Adrian Klaver
Date:
Subject: Re: Dumping functions with pg_dump