Skip to content

Instantly share code, notes, and snippets.

@andboson

andboson/postgres insert from sellect, random

Created July 29, 2016 07:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save andboson/efee4939c46205bf2c1bd372009ba387 to your computer and use it in GitHub Desktop.
Save andboson/efee4939c46205bf2c1bd372009ba387 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres insert from sellect, random
insert into questions(article, name, email, text, hash, sale_location_id, created_at, updated_at ) select 1111111 as article, 'drew' as name, 'i@s.com' as email, md5(generate_series(1,10)::text) as text, md5(generate_series(1,10)::text) as hash, 'shop_r002' as sale_location_id, to_date(now()::text, 'YYYY-MM-DD HH:MI:SS') as created_at, to_date(now()::text, 'YYYY-MM-DD HH:MI:SS') as updated_at;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment