Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DROP RULE(7)		PostgreSQL 9.6.19 Documentation		  DROP RULE(7)

NAME
       DROP_RULE - remove a rewrite rule

SYNOPSIS
       DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]

DESCRIPTION
       DROP RULE drops a rewrite rule.

PARAMETERS
       IF EXISTS
	   Do not throw	an error if the	rule does not exist. A notice is
	   issued in this case.

       name
	   The name of the rule	to drop.

       table_name
	   The name (optionally	schema-qualified) of the table or view that
	   the rule applies to.

       CASCADE
	   Automatically drop objects that depend on the rule, and in turn all
	   objects that	depend on those	objects	(see Section 5.13, "Dependency
	   Tracking", in the documentation).

       RESTRICT
	   Refuse to drop the rule if any objects depend on it.	This is	the
	   default.

EXAMPLES
       To drop the rewrite rule	newrule:

	   DROP	RULE newrule ON	mytable;

COMPATIBILITY
       DROP RULE is a PostgreSQL language extension, as	is the entire query
       rewrite system.

SEE ALSO
       CREATE RULE (CREATE_RULE(7)), ALTER RULE	(ALTER_RULE(7))

PostgreSQL 9.6.19		     2020			  DROP RULE(7)

NAME | SYNOPSIS | DESCRIPTION | PARAMETERS | EXAMPLES | COMPATIBILITY | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DROP_RULE&sektion=7&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help