Advertisement
Guest User

Untitled

a guest
Apr 12th, 2017
556
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. DROP TYPE IF EXISTS custom_token_type;
  2. CREATE TYPE custom_token_type AS (account TEXT, token TEXT);
  3.  
  4. INSERT INTO tokens (account, token, createAt)
  5. SELECT *, now() FROM json_populate_recordset(NULL::custom_token_type,
  6. '[{"account":"aaa@gmail.com", "token":"aaa7b58da9566a155976ffb62c1a60c0"},
  7. {"account":"bbb@gmail.com", "token":"bbbd038ea4efcdd55c906330932a06ab"},
  8. {"account":"ccc@gmail.com", "token":"ccc2b38497ab03bc367f12803808ae93"},
  9. {"account":"ddd@gmail.com", "token":"ddd917d645f9d8458c396f9daef9366c"},
  10. {"account":"eee@gmail.com", "token":"eee658453fce23684415b5e4ccb80ddd"}]');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement