Steve Howe <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
