Re: command line v GUI and COPY

On Tue, Oct 14, 2014 at 2:40 PM, John Polo <polo(at)okstate(dot)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.