This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
notes:postgres [2015/08/11 13:55] jiggak |
notes:postgres [2015/08/17 14:05] (current) jiggak |
||
---|---|---|---|
Line 5: | Line 5: | ||
</ | </ | ||
+ | < | ||
+ | bcp " | ||
+ | </ | ||
+ | <code bash> | ||
+ | #!/bin/bash | ||
+ | |||
+ | for f in *.data; do | ||
+ | echo $f | ||
+ | cat $f | \ | ||
+ | sed ' | ||
+ | # remove extra at end of file | ||
+ | sed '$ s/ | ||
+ | # add missing at start of file | ||
+ | sed '1 s/ | ||
+ | sed ' | ||
+ | sed ' | ||
+ | sed ' | ||
+ | sed ' | ||
+ | sed ' | ||
+ | sed ' | ||
+ | sed ' | ||
+ | # dos2unix identified these non-char bytes | ||
+ | tr -d ' | ||
+ | # dos2unix | \ | ||
+ | iconv -f WINDOWS-1252 -t UTF8 > $f.csv | ||
+ | done | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | \copy event (id, | ||
+ | select setval(' | ||
+ | </ |