Postgresql 中文操作指南
DROP USER MAPPING
DROP USER 映射 — 删除外部服务器的用户映射
DROP USER MAPPING — remove a user mapping for a foreign server
Synopsis
DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC } SERVER server_nameDescription
DROP USER MAPPING 从外部服务器中删除现有用户映射。
DROP USER MAPPING removes an existing user mapping from foreign server.
外部服务器的所有者可以为任何用户删除该服务器的用户映射。同样，如果已向用户授予服务器中的 USAGE 权限，用户可以删除他们自己的用户名用户映射。
The owner of a foreign server can drop user mappings for that server for any user. Also, a user can drop a user mapping for their own user name if USAGE privilege on the server has been granted to the user.
Parameters
-
IF EXISTS
-
Do not throw an error if the user mapping does not exist. A notice is issued in this case.
-
-
user_name
-
User name of the mapping. CURRENT_ROLE, CURRENT_USER, and USER match the name of the current user. PUBLIC is used to match all present and future user names in the system.
-
-
server_name
-
Server name of the user mapping.
-
Examples
如果存在，删除用户映射 bob 、服务器 foo ：
Drop a user mapping bob, server foo if it exists:
DROP USER MAPPING IF EXISTS FOR bob SERVER foo;