Re: Dump only functions - Mailing list pgsql-admin

AFAIK, there's no direct way to dump each function to a separate file. However, you can use system-defined function or system table to retrieve function structure and then write them to separate file each by using bash or perl scripting.

select prosrc from pg_proc where proname='foo';

or

select pg_get_functiondef('foo(integer)'::regprocedure::oid);