Re: command line v GUI and COPY
| От | jared |
|---|---|
| Тема | Re: command line v GUI and COPY |
| Дата | |
| Msg-id | CADss3AQ2qLBaCiqXQ0gDdJx7HF_XNaXMe8gaOt68KPYHQDaZ1w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: command line v GUI and COPY (John Polo <polo@okstate.edu>) |
| Ответы |
Re: command line v GUI and COPY
|
| Список | 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.
В списке pgsql-novice по дате отправления: