Steve Howe <howe(at)carcass(dot)dhs(dot)org> writes:
> howe=# select p.oid, n.nspname, pg_get_userbyid(p.proowner), proname
> from pg_proc as p, pg_namespace as n where pg_table_is_visible(p.oid);
> However, this situation lead me into another issue. The new conversion
> functions (utf8_to_big5, iso_to_alt, etc.) appear as listed in every
> new scheme. Is this correct ? Shouldn't them be listed only in
> pg_catalog?
They would be, if you had remembered the join condition ;-)
where ... and p.pronamespace = n.oid
regards, tom lane