ALTER USER MAPPING

A DDL command for modifying the mapping of a user to a foreign server

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.

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

DDL, Foreign Data Wrapper (FDW), User management

See also

CREATE USER MAPPING, DROP USER MAPPING, pg_user_mapping