DROP USER MAPPING

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

DROP USER MAPPING is a DDL command for removing the mapping of a PostgreSQL database user to a foreign server.

DROP USER MAPPING was added in PostgreSQL 8.4.

Change history

The syntax of DROP 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=# DROP USER MAPPING FOR postgres SERVER fdw_test;
DROP USER MAPPING

Categories

DDL, Foreign Data Wrapper (FDW), User management

See also

ALTER USER MAPPING, CREATE USER MAPPING, pg_user_mapping