Re: Dump only functions

On Wed, Mar 27, 2013 at 10:53 PM, Keith Ouellette <
Keith(dot)Ouellette(at)airgas(dot)com> wrote:

> Is there a way to dump only functions to a directory with each function
> as its own file in SQL format?
>
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);
or
Use other sources like pg_extractor tools.
http://www.keithf4.com/pg_extractor/

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

>
>
> Thanks,
>
> Keith
>
>
>