Tino Wildenhain wrote:
> 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 >funct
I'm not sure of your intentions but just as a suggestion, download
PGADMIN III. You can select a SCHEMA and do a BACKUP with many options
for your custom editing. (I'm new and that's the fastest way if you
have hundreds of functions & procedures like me) you can tweek the
generated backup file and
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 te
Cristian Prieto <[EMAIL PROTECTED]> schrieb:
> Any of you knows is there is any way in pg_dump or anything to dump just the
> functions from a database?
Net really a solution, but your defined functions are stored in
information_schema.routines
HTH, Andreas
--
Really, I'm not out to destroy M
Any of you knows is there is any way in pg_dump or anything
to dump just the functions from a database?
Thanks a lot in advance!
