DROP TABLE test; CREATE TABLE test (x int); DROP SEQUENCE seq; CREATE SEQUENCE seq; INSERT INTO test SELECT nextval('seq') FROM generate_series(1, 1000);