yiqingj · September 13, 2016 17:30
diff --git a/nuke-db.sql b/nuke-db.sql
 CREATE OR REPLACE FUNCTION truncate_tables(username IN VARCHAR) RETURNS void AS $$
 DECLARE
    statements CURSOR FOR
        SELECT tablename FROM pg_tables
        WHERE tableowner = username AND schemaname = 'public';
 BEGIN
    FOR stmt IN statements LOOP
        EXECUTE 'TRUNCATE TABLE ' || quote_ident(stmt.tablename) || ' CASCADE;';
    END LOOP;
 END;
 $$ LANGUAGE plpgsql;

 SELECT truncate_tables('www-data');
	CREATE OR REPLACE FUNCTION truncate_tables(username IN VARCHAR) RETURNS void AS $$
	DECLARE
	statements CURSOR FOR
	SELECT tablename FROM pg_tables
	WHERE tableowner = username AND schemaname = 'public';
	BEGIN
	FOR stmt IN statements LOOP
	EXECUTE 'TRUNCATE TABLE ' \|\| quote_ident(stmt.tablename) \|\| ' CASCADE;';
	END LOOP;
	END;
	$$ LANGUAGE plpgsql;

	SELECT truncate_tables('www-data');
No results found