Re: Dump only functions...

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Cristian Prieto <cristian(at)clickdiario(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump only functions...
Date: 2005-10-26 07:19:59
Message-ID: 1130311200.23228.75.camel@Andrea.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-10-26 07:43:56 Re: Autogenerated backup of a password protected database
Previous Message Tino Wildenhain 2005-10-26 07:15:20 Re: a stored procedure ..with integer as the parameter