Mitch Vincent wrote:
>
> This might sound like an ignorant question but how does one dump the
> function catalog?
The functions are in pg_proc. So generally, it would be "select * from
pg_proc". For the given problem, "select proname,probin from pg_proc;"
would be sufficient. Dump to a importable set of SQL statements, as in
pg_dump, can't be done - restoring a system table would hose the id
references, so exporting to a restorable format is of no use.
Sevo