Re: pg_dump option to dump only functions

Tom Lane wrote:
> Josh Berkus <josh@agliodbs.com> writes:
> >> I was wonderring, because I create a lot of server side utility functions,
> >> whether adding an option to pg_dump to just dump functions has been
> >> considered. I did a quick perusal of the code, and noted that there is a
> >> separate section within pg_dump to get the functions, but it is not able to
> >> be triggered separately from schema and data. Any reason why this wouldn't
> >> be a good(tm) idea?
> 
> > It would be an *excellent* idea, along with options to dump specific 
> > functions, and both specific and all views/types/operators.  Go for it.
> 
> I kinda thought we had a TODO entry for that already, but I see we
> don't.
> 
> Another thing you'd find yourself wanting very quickly is an option to
> follow dependencies, ie "dump these objects plus everything they depend
> on".  Otherwise you'd have to find the dependencies manually, which
> would get real tedious in any complex schema.
> 
> Proposed TODO entries for pg_dump:
> 
> * Allow selection of individual object(s) of all types, not just tables
> * In a selective dump, allow dumping of all dependencies of the objects

Added to TODO.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073