\set n 100
CREATE UNLOGGED TABLE compte(i SERIAL PRIMARY KEY, n INTEGER NOT NULL);
INSERT INTO compte(i, n)
  SELECT i, 0
  FROM generate_series(1, :n) AS i;
