restart_sequences.sql

CREATE FUNCTION restart_sequences() RETURNS VOID AS $$
DECLARE
	public_schema CONSTANT INTEGER NOT NULL DEFAULT 2200;
	statements CURSOR FOR SELECT 'ALTER SEQUENCE ' || relname || ' RESTART;' AS query
				FROM pg_class
				WHERE relkind = 'S'
				AND relnamespace = public_schema;
BEGIN
	FOR stmt IN statements LOOP
		EXECUTE stmt.query;
	END LOOP;
END;
$$ LANGUAGE plpgsql;