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, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
