Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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
