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:[email protected]] Sent: Wednesday, February 15, 2012 11:05 AM To: Rajan, Pavithra Cc: [email protected] Subject: Re: [GENERAL] Dump functions alone 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 <[email protected]> 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 <[email protected]> wrote: Hello all- Is there a way to just dump functions in a schema in to a txt file/ sql file ? Thank you.
