DROP_USER_MAPPING(7pg13)

💅 DROP USER MAPPING 💅

okay bestie, so this one is a PostgreSQL 13.23 page — yeah, the docs manual, we're fancy — and it's all about yeeting a user mapping off a foreign server. let's get into it 🫶

---

🌸 NAME 🌸

DROP_USER_MAPPING — removes a user mapping for a foreign server. that's it, that's the whole vibe. goodbye mapping, don't let the door hit you 💅

---

✨ SYNOPSIS ✨

DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_USER | PUBLIC } SERVER server_name

look at all those options, she's got range 🔥

---

🦋 DESCRIPTION 🦋

so like — DROP USER MAPPING removes an existing user mapping from a foreign server. iconic behavior, honestly.

now here's the permission tea ☕ 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 that user. basically: you can clean up your own mess, or the server owner can clean up everybody's 😭

---

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the user mapping doesn't exist. instead a notice gets issued. no dramatics, no explosion, just a lil heads up 💖
• user_name — the user name of the mapping. 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. she's giving main character energy, matching everyone 👑
• server_name — the server name of the user mapping. yep. that's the one 🦋

---

🌈 EXAMPLES 🌈

drop a user mapping bob, server foo, if it exists:

DROP USER MAPPING IF EXISTS FOR bob SERVER foo;

see how chill that was? no error, no stress, just IF EXISTS doing her thing ✨

---

💜 COMPATIBILITY 💜

DROP USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED) — standards girlie behavior, we love to see it. but the IF EXISTS clause? that's a PostgreSQL extension. homegrown. artisanal. locally sourced 🍓

---

⭐ SEE ALSO ⭐

• CREATE USER MAPPING (CREATE_USER_MAPPING(7)) — for when you wanna make one
• ALTER USER MAPPING (ALTER_USER_MAPPING(7)) — for when you wanna change one

iykyk, it's the full mapping lifecycle 💫

---

ok that's the whole page bestie, no cap, nothing skipped. every flag, every privilege, every standard reference — all present and accounted for 💅

---

PostgreSQL 13.23, dated 2025 — mwah, signed off, slay 💖✨