Re: Clarification on pg_attribute attrelid

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Clarification on pg_attribute attrelid
Дата
Msg-id 370678.1599833564@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Clarification on pg_attribute attrelid  (Mike Martin <redtux1@gmail.com>)
Список pgsql-sql
Mike Martin <redtux1@gmail.com> writes:
> Is it correct that calling attrelid::regclass will always return a
> non-schema qualified relation name

No.  regclassout will schema-qualify if the table isn't visible
according to the current search path.

I didn't check, but I think "not visible" would include the case
of "table is hidden by a temp table of the same name".

            regards, tom lane



В списке pgsql-sql по дате отправления:

Предыдущее
От: Mike Martin
Дата:
Сообщение: Clarification on pg_attribute attrelid
Следующее
От: Shaozhong SHI
Дата:
Сообщение: Postgres as a service for supporting common application users