Skip to content

Instantly share code, notes, and snippets.

@Dezinger

Dezinger/create-table-adn-fill-1m-recs.sql

Created November 23, 2013 13:47
Show Gist options
  • Save Dezinger/7614789 to your computer and use it in GitHub Desktop.
Save Dezinger/7614789 to your computer and use it in GitHub Desktop.
Download ZIP
Создаем и заполняем таблицу миллионом записей
Raw
create-table-adn-fill-1m-recs.sql
CREATE TABLE foo (c1 integer, c2 text);
INSERT INTO foo
  SELECT i, md5(random()::text)
  FROM generate_series(1, 1000000) AS i;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment