-- @Mat'sMug PostgreSQL behaves as I thought with TRUNCATE DROP TABLE IF EXISTS test; CREATE TABLE test ( a SERIAL, b TEXT ); INSERT INTO test (b) VALUES ('foo'),('bar'); -- SELECT a FROM test; -- 1, 2 DELETE FROM test; INSERT INTO test (b) VALUES ('foo'),('bar'); -- SELECT a FROM test; -- 3, 4 TRUNCATE TABLE test; INSERT INTO test (b) VALUES ('foo'),('bar'); -- SELECT a FROM test; -- 5, 6
00:00 - 19:0019:00 - 00:00
00:00 - 19:0019:00 - 00:00