PG_USER_MAPPING¶
PG_USER_MAPPING records the mappings from local users to remote.
It is accessible only to users with system administrator rights. You can use view PG_USER_MAPPINGS to query common users.
Name | Type | Reference | Description |
|---|---|---|---|
oid | oid |
| Row identifier (hidden attribute; must be explicitly selected) |
umuser | oid | PG_AUTHID.oid | OID of the local role being mapped, 0 if the user mapping is public |
umserver | oid | OID of the foreign server that contains this mapping | |
umoptions | text[] |
| Option used for user mapping. It is a keyword=value string. |