Glyn Astill <glynast...@yahoo.co.uk> writes:
> I was wondering if anyone could shed some light with type names returned by
> pg_catalog.format_type sometimes having the schema name prepended, and
> sometimes not? I'm calling it like format_type(pg_type.oid, NULL) .
General case: the schema name is used if the type wouldn't be found
without it, according to your current search_path.
There are some specific built-in types for which schema names are
never used, because their names are actually keywords according to SQL
(which a fortiori means there's no ambiguity on the lookup side).
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
