bifurqué depuis cliss21/betg
11 lignes
427 B
SQL
11 lignes
427 B
SQL
DO $$ DECLARE
|
|
r RECORD;
|
|
BEGIN
|
|
-- if the schema you operate on is not "current", you will want to
|
|
-- replace current_schema() in query with 'schematodeletetablesfrom'
|
|
-- *and* update the generate 'DROP...' accordingly.
|
|
FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = current_schema()) LOOP
|
|
EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(r.tablename) || ' CASCADE';
|
|
END LOOP;
|
|
END $$;
|