---
title: "pg_user_mapping"
id: catalog-pg-user-mapping
pg_version: "20devel"
---

<a id="catalog-pg-user-mapping"></a>

## 52.70. 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](view-pg-user-mappings.md) instead. 

**pg_user_mapping Columns**

| Column Type | Description | 
| --- | --- |
| `oid` `oid` | Row identifier |
| `umuser` `oid` (references [pg_authid](catalog-pg-authid.md).`oid`) | OID of the local role being mapped, or zero if the user mapping is public |
| `umserver` `oid` (references [pg_foreign_server](catalog-pg-foreign-server.md).`oid`) | The OID of the foreign server that contains this mapping |
| `umoptions` `text[]` | User mapping specific options, as "keyword=value" strings |