10 lines
306 B
MySQL
10 lines
306 B
MySQL
|
DO $$
|
||
|
|
DECLARE r RECORD;
|
||
|
|
BEGIN
|
||
|
|
FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public' AND tablename != 'django_migrations')
|
||
|
|
LOOP
|
||
|
|
RAISE NOTICE 'Truncating table %', r.tablename;
|
||
|
|
EXECUTE 'TRUNCATE TABLE ' || quote_ident(r.tablename) || ' CASCADE';
|
||
|
|
END LOOP;
|
||
|
|
END $$;
|