Re: Dump functions alone

From: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
To: "Rajan, Pavithra" <RAJANP(at)oru(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump functions alone
Date: 2012-02-15 16:05:24
Message-ID: CA+h6AhgePZhqVnjKD5Nc3m1TRLKSj1BQxt2Ru7=HAx_icxAaEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

One more thing you can also get it from pg_get_functiondef() system
function.

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

On Wed, Feb 15, 2012 at 9:32 PM, Raghavendra <
raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:

> You have two options.
>
> - Use contrib module pg_extractor
> https://github.com/omniti-labs/pg_extractor
> - Use pg_proc catalog to get function definition
>
>
> ---
> Regards,
> Raghavendra
> EnterpriseDB Corporation
> Blog: http://raghavt.blogspot.com/
>
>
>
> On Wed, Feb 15, 2012 at 6:59 PM, Rajan, Pavithra <RAJANP(at)oru(dot)com> wrote:
>
>> Hello all- Is there a way to just dump functions in a schema in to a txt
>> file/ sql file ? Thank you.****
>>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vojtěch Rylko 2012-02-15 16:12:26 Drop big index
Previous Message pcasper 2012-02-15 16:03:54 Reassigned Owned Error- unexpected classid 2328