Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages

RedHat 9 (Linux i386) - man page for drop_rule (redhat section 7)

DROP RULE(7)				   SQL Commands 			     DROP RULE(7)

NAME
       DROP RULE - remove a rewrite rule

SYNOPSIS
       DROP RULE name ON relation [ CASCADE | RESTRICT ]

   INPUTS
       name   The name of an existing rule to drop.

       relation
	      The name (optionally schema-qualified) of the relation the rule applies to.

       CASCADE
	      Automatically drop objects that depend on the rule.

       RESTRICT
	      Refuse to drop the rule if there are any dependent objects.  This is the default.

   OUTPUTS
       DROP RULE
	      Message returned if successful.

       ERROR: Rule "name" not found
	      This message occurs if the specified rule does not exist.

DESCRIPTION
       DROP  RULE drops a rule from the specified PostgreSQL rule system. PostgreSQL will immedi-
       ately cease enforcing it and will purge its definition from the system catalogs.

   NOTES
       The DROP RULE statement is a PostgreSQL language extension.

       Refer to CREATE RULE for information on how to create rules.

USAGE
       To drop the rewrite rule newrule:

       DROP RULE newrule ON mytable;

COMPATIBILITY
   SQL92
       There is no DROP RULE in SQL92.

SQL - Language Statements		    2002-11-22				     DROP RULE(7)


All times are GMT -4. The time now is 08:21 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password