Re: command line v GUI and COPY - Mailing list pgsql-novice

On Tue, Oct 14, 2014 at 2:40 PM, John Polo <polo@okstate.edu> wrote:

 

This is how the data originally appears in the file. The error says it was in row 2. It looked like there was an extra pair of quotes and then an odd quote at the very end.
"CN","PLT_CN","INVYR","STATECD","UNITCD","COUNTYCD","PLOT","SUBP","SUBPTYP","BNDCHG","CONTRAST","AZMLEFT","AZMCORN","DISTCORN","AZMRIGHT","CYCLE","SUBCYCLE","CREATED_BY","CREATED_DATE","CREATED_IN_INSTANCE","MODIFIED_BY","MODIFIED_DATE","MODIFIED_IN_INSTANCE"
"202492243010854","157287634010478",2008,40,1,5,131,2,1,,2,276,0,,70,7,1,"",2011-05-02,"10854","",,""


John

Hey John,

Maybe I am misunderstanding, but that copied into a table fine, did you paste the correct row into the email?

I placed the text you provided than executed:

create table test

(

CN  character varying,

PLT_CN  character varying,

INVYR  character varying,

STATECD  character varying,

UNITCD  character varying,

COUNTYCD  character varying,

PLOT  character varying,

SUBP  character varying,

SUBPTYP  character varying,

BNDCHG  character varying,

CONTRAST  character varying,

AZMLEFT  character varying,

AZMCORN  character varying,

DISTCORN  character varying,

AZMRIGHT  character varying,

CYCLE  character varying,

SUBCYCLE  character varying,

CREATED_BY  character varying,

CREATED_DATE  date,

CREATED_IN_INSTANCE  character varying,

MODIFIED_BY  character varying,

MODIFIED_DATE  character varying,

MODIFIED_IN_INSTANCE  character varying

);

copy test

from '/for_import/test_data.txt'

with delimiter as ','

csv header

null as '';

And everything came through without errors.