"Carlo Stonebanks" <stonec.regis...@sympatico.ca> writes:
>> Afaik no, you can make a schema-dump and extract the function
>> declarations from the dump.
> Yeah, that's what I was doing. Bloody tedious. Thanks anyway!
It seems like it could be automated.
pg_dump -Fc -s mydb >mydb.dump
pg_restore -l mydb.dump | grep FUNCTION >mydb.list
pg_restore -L mydb.list mydb.dump >functionsonly.txt
(or something more or less like that --- too early in the morning...)
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
