Thank you. I tried pg_extractor and it work almost perfect. I have just one question. We do overloading of a function name (using different parameters) and I think it puts all overlaoded functions in the same file (those with the same file name that is). Is there a way to separate them?
Thanks again for everyones help. ________________________________ From: Scott Mead [sco...@openscg.com] Sent: Wednesday, March 27, 2013 1:49 PM To: Raghavendra Cc: Keith Ouellette; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Dump only functions On Wed, Mar 27, 2013 at 1:43 PM, Raghavendra <raghavendra....@enterprisedb.com<mailto:raghavendra....@enterprisedb.com>> wrote: On Wed, Mar 27, 2013 at 10:53 PM, Keith Ouellette <keith.ouelle...@airgas.com<mailto:keith.ouelle...@airgas.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
