DROP POLICY

    Description

    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 viaALTER TABLE, then the default-deny policy will be used.ALTER TABLE ... DISABLE ROW LEVEL SECURITYcan be used to disable row level security for a table, whether policies for the table exist or not.

    IF EXISTS

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

    table_name

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

    CASCADE

    RESTRICT

    Examples

    To drop the policy calledon the table namedmy_table:

    1. DROP POLICY p1 ON my_table;

    DROP POLICYis aPostgreSQLextension.

    See Also

    ,