Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Databases - Practical PostgreSQL
Previous Page Home Next Page

DROP RULE

Name

DROP RULE -- Removes a rule from a database.

Synopsis

DROP RULE 
name
 [, ...]

Parameters

name

The name of an existing rule to drop. You may drop multiple rules by specifying their names in a comma-delimited list.

Results

DROP

The message returned when a rule is dropped successfully.

ERROR: Rule or view " name " not found

The error returned if the specified rule name does not exist.

Description

Use the DROP RULE command to remove a rule from a PostgreSQL database. When a rule is dropped, the change is effective immediately. A rule becomes unavailable as soon as it is dropped, and its definition is completely removed from the database system.

Example

The following example drops the sync_stock_with_editions rule:

booktown=# 
DROP RULE sync_stock_with_editions;

DROP
Databases - Practical PostgreSQL
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire