Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 4/9/24 08:12, Thiemo Kellner wrote:
>>> PG_CATALOG.PG_ROLES.ROLNAME := 'snowrunner_reader';
>>>
>>> Is being seen as DB_NAME.TABLE_NAME.COLUMN_NAME.
No, it's being seen as DB_NAME.SCHEMA_NAME.TYPE_NAME.
> Because you did not do?:
> PG_CATALOG.PG_ROLES.ROLNAME%type
Exactly. The %type bit is important.
regards, tom lane