Drop all policies on a given table in PostgreSQL

drop_policies.sql

CREATE OR REPLACE FUNCTION drop_all_policies_on_table(
    target_schema text,
    target_table_name text
) RETURNS void LANGUAGE plpgsql AS $$
DECLARE 
    policy_name text;
    sql_text    text;
BEGIN 
    FOR policy_name IN (
        SELECT policyname 
        FROM pg_policies 
        WHERE schemaname = target_schema AND tablename = target_table_name
    )
    LOOP
        sql_text := format('DROP POLICY "%s" on %I.%I', policy_name, target_schema, target_table_name);
        RAISE NOTICE '%', sql_text;
        EXECUTE sql_text;
    END LOOP;
END $$;