Re: pg_dump option to dump only functions

Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073