Clarification on pg_attribute attrelid

Поиск
Список
Период
Сортировка
От Mike Martin
Тема Clarification on pg_attribute attrelid
Дата
Msg-id CAOwYNKYJ-MkzvEbfnHGFpYEisZUz6iE4-md3z5b0ZPV-7dZ_1w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Clarification on pg_attribute attrelid
Список pgsql-sql
Is it correct that calling attrelid::regclass will always return a non-schema qualified relation name
ie:
WHERE there is a temp table and a permanent table of the the same name
SELECT attrelid::regclass
FROM pg_attribute
WHERE attrelid = 'tagdata'::regclass

will always use the "current" temp table of the name or the permanent table  if no temp table exists without schema qualification.

So this would be the same as a normal select , ie:uses temp table/permanent table as appropriate

thanks

Mike

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