Re: Dump only functions

On Wed, Mar 27, 2013 at 1:43 PM, Raghavendra <
raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:

> 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/
>

+1 here. pg_extractor is my personal favorite for this type of thing. It
can give you all of your objects as separate files if you'd like.

--Scott

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