Обсуждение: Restore a especific function
Hello list, Is there a way to restore a specific function from backup file created with pg_dump. Thanks in advance, -- Sinceramente, Josué Maldonado. "La monogamia es como estar obligado a comer papas fritas todos los dias." -- Henry Miller. (1891-1980) Escritor estadounidense.
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)
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)