DROP_POLICY(7pg13)

🌸 NAME 🌸

DROP POLICY — remove a row level security policy from a table. This is the manual page for DROP_POLICY(7pg13) (also known as DROP POLICY(7)), straight from the PostgreSQL 13.23 documentation, and yes you're in the right place, bestie. 💖

---

✨ SYNOPSIS ✨

okay so the whole vibe is this one line:

DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]

---

💖 DESCRIPTION 💖

okay so DROP POLICY removes the specified policy from the table. That's the main character move. 💅

Note that if the last policy is removed for a table and the table still has row level security enabled via ALTER TABLE, then the default-deny policy will be used. 😭

ALTER TABLE ... DISABLE ROW LEVEL SECURITY can be used to disable row level security for a table, whether policies for the table exist or not. ✨

---

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the policy does not exist. A notice is issued in this case. 🫶
• name — the name of the policy to drop. 💅
• table_name — the name (optionally schema-qualified) of the table that the policy is on. 🎀
• CASCADE — does not have any effect, since there are no dependencies on policies. 💀
• RESTRICT — does not have any effect, since there are no dependencies on policies. 💀

---

🦋 EXAMPLES 🦋

To drop the policy called p1 on the table named my_table, you literally run:

DROP POLICY p1 ON my_table;

slay. that's it. 🦋

---

⭐ COMPATIBILITY ⭐

DROP POLICY is a PostgreSQL extension. periodt. 💅

---

💜 SEE ALSO 💜

CREATE POLICY (CREATE_POLICY(7)), ALTER POLICY (ALTER_POLICY(7)) — go read those too, bestie. iykyk 🦋

---

mwah 💋 — that's the DROP POLICY(7) page from PostgreSQL 13.23, dated 2025. now go drop that policy, bestie 🫶🌈