Re: Dump functions alone - Mailing list pgsql-general

From Rajan, Pavithra
Subject Re: Dump functions alone
Date
Msg-id 924146AEF992184E84C7F5A5D6E2C87D0DB40B4B@EXCHMB05.conedison.net
Whole thread Raw
In response to Re: Dump functions alone  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general

Thank you. The PGExtractor is interesting!  I was trying to get all the function declaration and definition ( about 400+) by this method

 

pg_dump -Fc -v -s schemaname -f temp.dump yourdatabase

pg_restore -l temp.dump | grep FUNCTION >functionlist

pg_restore -L functionlist temp.dump >yourfunctions.sql

 

mentioned in http://archives.postgresql.org/pgsql-general/2005-10/msg01633.php

 

I’ll try this and your solutions as well

 

 

 

 

From: Raghavendra [mailto:raghavendra.rao@enterprisedb.com]
Sent: Wednesday, February 15, 2012 11:05 AM
To: Rajan, Pavithra
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dump functions alone

 

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

 

---

Regards,

Raghavendra

EnterpriseDB Corporation



On Wed, Feb 15, 2012 at 9:32 PM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:

You have two options.

 

---

Regards,

Raghavendra

EnterpriseDB Corporation



On Wed, Feb 15, 2012 at 6:59 PM, Rajan, Pavithra <RAJANP@oru.com> wrote:

Hello all-  Is there a way to just dump functions in a schema in to a txt file/ sql file ?  Thank you.

 

 

pgsql-general by date:

Previous
From: "Bob Pawley"
Date:
Subject: DDL Triggers
Next
From: Steve Crawford
Date:
Subject: Re: DDL Triggers