Re: Clarification on pg_attribute attrelid - Mailing list pgsql-sql

From Tom Lane
Subject Re: Clarification on pg_attribute attrelid
Date
Msg-id 370678.1599833564@sss.pgh.pa.us
Whole thread Raw
In response to Clarification on pg_attribute attrelid  (Mike Martin <redtux1@gmail.com>)
List 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 by date:

Previous
From: Mike Martin
Date:
Subject: Clarification on pg_attribute attrelid
Next
From: Shaozhong SHI
Date:
Subject: Postgres as a service for supporting common application users