Hi,
I want to import from a .txt file, I usually use:
COPY noticies FROM '/home/teixi/_6tm_/_elbulli/premsai.txt' USING
DELIMITERS '|' \g
a) If table 'noticies' has a date row and is null on data file it claims:
Unable to import date filed ''
so how to admit date fields null?
b) When there are some 'carriage returns' on a field in the data file is
understood as a new
|row1data1|row1data2|row1data3|^M
|row2data1^M
stillrow2data1|row2data2|row2data2|^M
is interpreted as a 3 row data file when in reallity is a 2 row data file.
how could I handle this when importing ?
bests from barcelona,
jaume teixi
ps: weather loops between 5ºC to 30ºC, crazy.