Re: The COPY command and csv files

E. Matthew Finnin wrote:
> **I apologize in advance if this is a familiar question, but I couldn't
> find an answer**
>
> I am attempting to copy a csv file into a table, but no matter what I
> can think of I get one of two errors. I am using Postgresql 8.1.2.
>
> 1.) Here is the first COPY command I gave:
> COPY pwt61_oecd FROM stdin
> WITH DELIMITER AS ','
> CSV QUOTE AS ' " '

Should be '"', not ' " '. In fact, DELIMITER and QUOTE are the
defaults, so there is no need to specify them.

> NULL AS 'na'
> ;

> 2.) Curious if I would get the same error, I attemtped to use the
> \copy command in psql, but this time I removed the column headers from
> the csv file:
>
> \copy pwt61_oecd FROM '/home/.../data/pwt61_oecd2.csv' WITH DELIMITER
> AS ',' CSV QUOTE AS ' " ' NULL AS 'na'
>
> And the error report:
> ERROR: invalid input syntax for type numeric: "na"
> CONTEXT: COPY pwt61_oecd, line 1, column cgnp: "na"
>

Yep, same ' " ' problem. We disallows multi-character delimiters in
current CVS, but you might not have the 8.1.X backpatch.

If you have continued problems, please send us the table schema and a
line that is failing and we can help you get it working.

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +