Skip to content
Snippets Groups Projects
Select Git revision
  • b5572dfb9acb2eedfe642823261b6288681d81f7
  • master default
2 results

Program.cs

Blame
  • drop-all.sql 448 B
    -- Delete all tables and types
    
    SET ROLE mo_submit;
    
    DO $$ DECLARE
      r RECORD;
    BEGIN
      FOR r IN (SELECT tablename FROM pg_tables WHERE tableowner=current_user) LOOP
        EXECUTE 'DROP TABLE ' || quote_ident(r.tablename) || ' CASCADE';
      END LOOP;
    
      FOR r IN (SELECT * FROM pg_type WHERE typcategory='E' AND typowner=(SELECT oid FROM pg_roles WHERE rolname=current_user)) LOOP
        EXECUTE 'DROP TYPE ' || quote_ident(r.typname);
      END LOOP;
    END $$;