From: | Greg Corradini <gregcorradini(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, rod(at)iol(dot)ie |
Subject: | Re: Dumping functions with pg_dump |
Date: | 2011-04-06 00:24:13 |
Message-ID: | BANLkTinwaQPFqNT+CqiKfsDpf55eC4geuQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Apr 5, 2011 at 4:30 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)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(dot)klaver(at)gmail(dot)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)
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-04-06 02:15:30 | Re: Dumping functions with pg_dump |
Previous Message | Perry Smith | 2011-04-05 23:32:47 | Re: unique amount more than one table |