Glyn Astill <glynastill@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
