New answers tagged

1

Removing the explicit cast to tstrange worked. The new CSV file looks like t_range|field1 '[2014-06-02 07:00:00,infinity)'|'sometext1' '[2014-06-02 07:00:00,infinity)'|'sometext2' It seems to me that \copy is fine with automatically attempting to cast to the appropriate datatypes, but the explicit cast causes it to choke. One can also simplify the CSV ...


0

You could try using sed and substitute | (the pipe character - not normally found in data dumps) for the " (double quote) character sed -i 's/"/|/g' My_File.csv sed -i does an inline replace - take a backup before messing with your original file. If you're on Windows - as you appear to be, you can get sed functionality from the answer here or use the ...



Top 50 recent answers are included