Still some problems importing with COPY

Started by Jaume Teixialmost 25 years ago1 messages
#1Jaume Teixi
teixi@6tems.com

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.