Catalogs: 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 50-57. pg_user_mapping Columns

Name	Type	References	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`	`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		Next
`pg_type`	Up	System Views

Links:

https://www.postgresql.org/docs/9.6/static/catalog-pg-user-mapping.html

doc_PostgreSQL

2016-10-12 11:32:42

Comments

Popular Articles

Catalogs: pg_user_mappings The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of pg_user_mapping that le

Catalogs: pg_user The view pg_user provides access to information about database users. This is simply a publicly readable view of pg_shadow that blanks out the passwo

Catalogs: pg_ts_config_map The pg_ts_config_map catalog contains entries showing which text search dictionaries should be consulted, and in what order, for each output token ty

Catalogs: pg_statistic The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by ANALYZE and subsequently used by the quer

Catalogs: pg_opclass The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular data typ