DROP USER MAPPING

An SQL 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

Examples

Basic usage example for DROP USER MAPPING:

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

Attempting to drop a mapping for a non-existent user mapping:

postgres=# DROP USER MAPPING FOR postgres SERVER pg_fdw;
ERROR:  user mapping for "postgres" does not exist for server "pg_fdw"

Categories

DDL, Foreign Data Wrapper (FDW), SQL command, Users and roles

See also

ALTER USER MAPPING, CREATE USER MAPPING, pg_user_mapping