On Wed, Mar 27, 2013 at 10:53 PM, Keith Ouellette < 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/ --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ > > > Thanks, > > Keith > > >