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

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), SQL command, User management

See also

ALTER USER MAPPING, CREATE USER MAPPING, pg_user_mapping