Advertisement
Guest User

Untitled

a guest
Dec 30th, 2019
230
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. LOAD CSV
  2. FROM stdin
  3. (
  4. COUNTER,
  5. DEVICE_ID,
  6. MAC_ADDRESS
  7. )
  8. INTO postgresql://{{PGUSER}}:{{PGPASSWORD}}@{{PGHOST}}/{{PGDATABASE}}?devices
  9. (
  10. DEVICE_ID,
  11. MAC_ADDRESS
  12. )
  13. WITH fields terminated by ' ',
  14. skip header = 1,
  15. TRUNCATE
  16. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement