Re: Type Name / Internal name returned by pg_catalog.format_type with/without prepended schema name? - Mailing list pgsql-general

Glyn Astill <glynastill@yahoo.co.uk> writes:
>> From: Tom Lane <tgl@sss.pgh.pa.us>
>> General case: the schema name is used if the type wouldn't be found
>> without it, according to your current search_path.

> However none of that explains why one of the types is returned with the schema name and the other is not, both are in
thesame schema which is in the current search_path. 

It's difficult to comment on that without a concrete example, but
"visible according to search_path" does not only mean "in a schema
that's in search_path".  It also requires "not masked by a similarly
named object appearing earlier in the path".

            regards, tom lane