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@xxxxxxxxxxxxxxxx] One more thing you can also get it from pg_get_functiondef() system function. On Wed, Feb 15, 2012 at 9:32 PM, Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> wrote: You have two options.
On Wed, Feb 15, 2012 at 6:59 PM, Rajan, Pavithra <RAJANP@xxxxxxx> wrote: Hello all- Is there a way to just dump functions in a schema in to a txt file/ sql file ? Thank you. |
