This shows you the differences between two versions of the page.
Next revision | Previous revision Last revision Both sides next revision | ||
notes:postgres [2015/08/11 13:54] jiggak created |
notes:postgres [2015/08/17 14:04] jiggak |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | | + | <code sql> |
- | create role josh with login; | + | -- basic access by nix user |
- | create database edc owner josh; | + | create role josh with login; |
+ | create database edc owner josh; | ||
+ | </ | ||
+ | < | ||
+ | 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(' | ||
+ | </ |