Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER - Mailing list pgsql-admin

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> Specifically:

> select id.*, pg_proc.*, tableoid from pg_proc,
> pg_identify_object(1255,oid,0) as id;

Personally, I'd cast the procedure's OID to regprocedure instead.
More or less the same output, doesn't require magic numbers.

(Although I think you could write "pg_proc.tableoid" instead
of "1255", if you're intent on using pg_identify_object.)

            regards, tom lane