Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LOAD CSV
- FROM stdin
- (
- COUNTER,
- DEVICE_ID,
- MAC_ADDRESS
- )
- INTO postgresql://{{PGUSER}}:{{PGPASSWORD}}@{{PGHOST}}/{{PGDATABASE}}?devices
- (
- DEVICE_ID,
- MAC_ADDRESS
- )
- WITH fields terminated by ' ',
- skip header = 1,
- TRUNCATE
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement