Re: Restore a especific function - Mailing list pgsql-general

From Thomas F.O'Connell
Subject Re: Restore a especific function
Date
Msg-id 848EC7DE-0DDC-11D9-821C-000D93AE0944@sitening.com
Whole thread Raw
In response to Re: Restore a especific function  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
There's also pg_restore -P. See:

http://www.postgresql.org/docs/7.4/static/app-pgrestore.html

-tfo

On Sep 23, 2004, at 7:34 PM, Alvaro Herrera wrote:

> On Thu, Sep 23, 2004 at 02:57:30PM -0600, Josué Maldonado wrote:
>
> Hola,
>
>> Is there a way to restore a specific function from backup file created
>> with pg_dump.
>
> If you used pg_dump -Ft or -Fc, you do it with pg_restore -L/-l.
> Otherwise (i.e. plain SQL dump) you have to edit the dump with a text
> editor to extract the function definition.
>
> --
> Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
> "La grandeza es una experiencia transitoria.  Nunca es consistente.
> Depende en gran parte de la imaginación humana creadora de mitos"
> (Irulan)

pgsql-general by date:

Previous
From: Matthew Hixson
Date:
Subject: Re: data modeler
Next
From: Frans
Date:
Subject: default value problem in postgresql 7.4.5-2