"David G. Johnston" <david.g.johnston@xxxxxxxxx> 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
