On Tue, Apr 5, 2011 at 4:30 PM, Adrian Klaver <adrian.kla...@gmail.com>wrote:
> On Tuesday, April 05, 2011 4:19:56 pm Raymond O'Donnell wrote: > > On 06/04/2011 00:15, Greg Corradini wrote: > > > Hello, > > > Is it possible yet in 8.4 to pg_dump specific functions without having > > > to do the whole pg_restore thing? > > > > If I understand correctly what you're trying to do, a handy alternative > > is to use pgAdmin, right click on the function in the tree view, and > > select Scripts -> Create. > > > > Ray. > > In addition, from inside psql do \ef function_name. This opens the function > in > an editor from which you can save it elsewhere. > If you are talking a lot of functions then you can use the -l and -L > options to > pg_restore to create a TOC list that can be edited to contain only the > functions > you want. These than can either be restored to a database or file. > > -- > Adrian Klaver > adrian.kla...@gmail.com > Thx for the replies Adrian and Jerry, Those are both options. Jerry, your suggestion is the work around I've already used. Adrian, I did not know you could do that. Still...I was looking for something that worked inline with pg_dump...and it looks like pg_restore is still the major game in town. It would be nice if pg_dump got some option flags to do this sort of thing (though I'm naive on why this doesn't exist in the first place)
