"Carlo Stonebanks" <stonec.register@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
