Re: Dump only functions... - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Dump only functions...
Date
Msg-id 1130311200.23228.75.camel@Andrea.peacock.de
Whole thread Raw
In response to Dump only functions...  ("Cristian Prieto" <cristian@clickdiario.com>)
Responses Re: Dump only functions...
List pgsql-general
Am Dienstag, den 18.10.2005, 15:31 -0600 schrieb Cristian Prieto:
> Any of you knows is there is any way in pg_dump or anything to dump
> just the functions from a database?

pg_dump -Fc -v -f temp.dump yourdatabase
pg_restore -l temp.dump | grep FUNCTION >functionlist
pg_restore -L functionlist temp.dump >yourfunctions.sql

of course you can just use your regular dump and so
skip the first part.

HTH
Tino


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: a stored procedure ..with integer as the parameter
Next
From: Richard Huxton
Date:
Subject: Re: Autogenerated backup of a password protected database