Create temp table with tons of records

Tags: sql, postgres

This might be useful for doing some rudimentary performance testing.

See also Large SQL data migrations

This example generates a temp table called things, with 1 million rows.

\timing

CREATE SCHEMA IF NOT EXISTS temp;

CREATE TABLE temp.things AS
SELECT
  seq AS id,
  'Name-' || seq::TEXT as name
FROM GENERATE_SERIES(1, 1000000) AS t(seq);