Skip to content

Instantly share code, notes, and snippets.

@kaievns

kaievns/gist:acb23149b66418ba340c

Created July 29, 2014 00:44
Show Gist options
  • Save kaievns/acb23149b66418ba340c to your computer and use it in GitHub Desktop.
Save kaievns/acb23149b66418ba340c to your computer and use it in GitHub Desktop.
Download ZIP
How to populate PostgreSQL with dummy data
Raw
gistfile1.sql
CREATE TABLE t_random AS SELECT s, md5(random()::text) FROM generate_Series(1,5) s;
INSERT INTO t_random VALUES (generate_series(1,1000000000), md5(random()::text));
SELECT pg_size_pretty(pg_relation_size('t_random'));
@runlevel5
Copy link

generate_Series vs generate_series - same?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment