Thread

Still some problems importing with COPY

Jaume Teixi <teixi@6tems.com> — 2001-02-28T15:44:54Z

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.