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:
Show quoted text
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)