PostgreSQL 8.4.7 Documentation
Prev | Fast Backward | Chapter 44. System Catalogs | Fast Forward | Next

# 44.43. `pg_user_mapping`

The catalog `pg_user_mapping` stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view `pg_user_mappings` instead.

Table 44-44. `pg_user_mapping` Columns

Name | Type | References | Description
--- | --- | --- | ---
`umuser` | `oid` | ``pg_authid`.oid` | OID of the local role being mapped, 0 if the user mapping is public
`umserver` | `oid` | ``pg_foreign_server`.oid` | The OID of the foreign server that contains this mapping
`umoptions` | `text[]` |  | User mapping specific options, as "keyword=value" strings.

Prev | Home | Next
`pg_type` | Up | System Views