471,092 Members | 1,566 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

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.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #1
2 1740
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)
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2
There's also pg_restore -P. See:

http://www.postgresql.org/docs/7.4/s...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)


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by GL | last post: by
6 posts views Thread by SS | last post: by
3 posts views Thread by cefrancke | last post: by
1 post views Thread by VBA | last post: by
reply views Thread by mitrofun63 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.