From 293913568e6a7a86fd1479e1cff8e2ecb58d6568 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 15:44:03 +0200 Subject: Adding upstream version 16.2. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/sql-droppolicy.html | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 doc/src/sgml/html/sql-droppolicy.html (limited to 'doc/src/sgml/html/sql-droppolicy.html') diff --git a/doc/src/sgml/html/sql-droppolicy.html b/doc/src/sgml/html/sql-droppolicy.html new file mode 100644 index 0000000..e10fd0f --- /dev/null +++ b/doc/src/sgml/html/sql-droppolicy.html @@ -0,0 +1,30 @@ + +DROP POLICY
DROP POLICY
Prev UpSQL CommandsHome Next

DROP POLICY

DROP POLICY — remove a row-level security policy from a table

Synopsis

+DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]
+

Description

+ DROP POLICY removes the specified policy from the table. + Note that if the last policy is removed for a table and the table still has + row-level security enabled via ALTER TABLE, then the + default-deny policy will be used. ALTER TABLE ... DISABLE ROW + LEVEL SECURITY can be used to disable row-level security for a + table, whether policies for the table exist or not. +

Parameters

IF EXISTS

+ Do not throw an error if the policy does not exist. A notice is issued + in this case. +

name

+ The name of the policy to drop. +

table_name

+ The name (optionally schema-qualified) of the table that + the policy is on. +

CASCADE
RESTRICT

+ These key words do not have any effect, since there are no + dependencies on policies. +

Examples

+ To drop the policy called p1 on the table named + my_table: + +

+DROP POLICY p1 ON my_table;
+

Compatibility

+ DROP POLICY is a PostgreSQL extension. +

Prev Up Next
DROP OWNED Home DROP PROCEDURE
\ No newline at end of file -- cgit v1.2.3