Delete a rule within PostgreSQL

Question

I have created a rule using the following syntax:

CREATE [ OR REPLACE ] RULE name AS ON event
TO table [ WHERE condition ]
DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) }

I now want to delete this rule and have been searching the documentation to explain how to do so, but I cannot seem to find the answer I am looking for.

Any advice would be appreciated.

Thanks.

Vladimir · Accepted Answer · 2023-01-19 04:58:40Z

2

Starting with PostgreSQL 8.2, the syntax is:

DROP RULE [ IF EXISTS ] name ON relation [ CASCADE | RESTRICT ]

Example:

DROP RULE newrule ON mytable;

edited Jan 19, 2023 at 4:58

Vladimir

6,8602 gold badges36 silver badges40 bronze badges

answered May 30, 2013 at 11:38

Cristan

14.6k8 gold badges74 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MichielB · Accepted Answer · 2017-05-10 14:51:17Z

1

The syntax is:

DROP RULE

ref: https://www.postgresql.org/docs/current/static/sql-droprule.html

edited May 10, 2017 at 14:51

MichielB

4,3441 gold badge33 silver badges39 bronze badges

answered Apr 1, 2012 at 18:04

guettli

27.7k109 gold badges423 silver badges779 bronze badges

Collectives™ on Stack Overflow

Delete a rule within PostgreSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related