pg_user_mapping

The catalog pg_user_mapping stores the mappings from local user to remote.

Columns 4

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`umuser`	`oid`	OID of the local role being mapped, or zero if the user mapping is public pg_authid.oid
`umserver`	`oid`	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

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`umuser`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`umserver`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`umoptions`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 4

Definition snapshot: english-manuals:10dfd978d6e3126606e6d6b64f8… · English manual source