System Catalogs / System catalogs
pg_user_mapping
Read the PG 18 manualThe catalog pg_user_mapping stores the mappings from local user to remote.
Reading PG 18current·documented in 19 of 24 versions, 8.4 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 4
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 4
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
umuser | oidNOT NULL | OID of the local role being mapped, or zero if the user mapping is public pg_authid.oid |
umserver | oidNOT NULL | The OID of the foreign server that contains this mapping pg_foreign_server.oid |
umoptions | text[] | User mapping specific options, as “keyword=value” strings |
Column history across versions
Definition snapshot: english-manuals:9aa94a2e66be6f473035051fc84… · English manual source