Re: Dumping functions with pg_dump

On Apr 6, 2011, at 4:45 AM, 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 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?
>
> thx

Not from pg_dump. You can use psql to dump the specific functions using pg_get_functiondef(oid)
psql -c "select pg_get_functiondef(oid) from pg_proc where proname='<fnction name>' and pronamespace=(select oid from pg_namespace where nspname='schemaname');" <dbname>;

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com