Re: Deleting Functions

"Jim Buttafuoco" <jim(at)contactbda(dot)com> writes:
> select 'drop function ' || nspname || '.' || proname || '(' || pg_catalog.oidvectortypes(p.proargtypes) || ');' from
> pg_proc p join pg_namespace b on (p.pronamespace=b.oid) where nspname='public';

Seems like you could do that more easily with regprocedure:

select 'drop function ' || p.oid::regprocedure || ';' from
pg_proc p join pg_namespace b on (p.pronamespace=b.oid) where nspname='public';

[ tries it ... ] ... except that there's no regprocedure-to-text cast.
How annoying :-(

regards, tom lane