Adrian Klaver <[email protected]> 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
