From 46651ce6fe013220ed397add242004d764fc0153 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:15:05 +0200 Subject: Adding upstream version 14.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/sql-alterrule.html | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) create mode 100644 doc/src/sgml/html/sql-alterrule.html (limited to 'doc/src/sgml/html/sql-alterrule.html') diff --git a/doc/src/sgml/html/sql-alterrule.html b/doc/src/sgml/html/sql-alterrule.html new file mode 100644 index 0000000..3639295 --- /dev/null +++ b/doc/src/sgml/html/sql-alterrule.html @@ -0,0 +1,25 @@ + +ALTER RULE
ALTER RULE
Prev UpSQL CommandsHome Next

ALTER RULE

ALTER RULE — change the definition of a rule

Synopsis

+ALTER RULE name ON table_name RENAME TO new_name
+

Description

+ ALTER RULE changes properties of an existing + rule. Currently, the only available action is to change the rule's name. +

+ To use ALTER RULE, you must own the table or view that + the rule applies to. +

Parameters

name

+ The name of an existing rule to alter. +

table_name

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

new_name

+ The new name for the rule. +

Examples

+ To rename an existing rule: +

+ALTER RULE notify_all ON emp RENAME TO notify_me;
+

Compatibility

+ ALTER RULE is a + PostgreSQL language extension, as is the + entire query rewrite system. +

Prev Up Next
ALTER ROUTINE Home ALTER SCHEMA
\ No newline at end of file -- cgit v1.2.3