• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Useful articles

Useful links

ALTER USER MAPPING

ALTER USER MAPPING is a DDL command for modifying the mapping of a PostgreSQL database user to a foreign server

ALTER USER MAPPING was added in PostgreSQL 8.4.

Change history

The syntax of ALTER USER MAPPING has not been modified since it was added in PostgreSQL 8.4.

• PostgreSQL 8.4
  • added (commit cae565e5)

Examples

postgres=# CREATE USER MAPPING FOR CURRENT_USER SERVER fdw_test OPTIONS (user 'foo', password 'bar');
CREATE USER MAPPING

postgres=# ALTER USER MAPPING FOR postgres SERVER fdw_test OPTIONS (SET password 'baz');
ALTER USER MAPPING

Categories

See also