Contents
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.
- 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