Joshua Ziggas jziggas
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| openapi: 3.0.1 | |
| info: | |
| title: gateway.marvel.com | |
| version: Cable | |
| servers: | |
| - url: http://gateway.marvel.com/ | |
| tags: | |
| - name: public | |
| paths: | |
| /v1/public/characters: |
jziggas
/ drop_policies.sql
Created
October 3, 2023 14:44
Drop all policies on a given table in PostgreSQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
OlderNewer