Postgres Pro
Downloads
Home   >   mailing lists

pg import text data to not null table comma error but semicolon right - Mailing list pgsql-bugs

From 王学敏
Subject pg import text data to not null table comma error but semicolon right
Date
Msg-id 21c10616.195a8.146d82287df.Coremail.wang1352083@163.com
Whole thread Raw
Responses Re: pg import text data to not null table comma error but semicolon right  (David G Johnston <david.g.johnston@gmail.com>)
Re: pg import text data to not null table comma error but semicolon right  (Matheus de Oliveira <matioli.matheus@gmail.com>)
List pgsql-bugs
Tree view
Hi,
when i imort data from csv to table ,there may be some error
create table t(d1 text not null,d2 text not null,d3 text not null);

 \copy t(d1,d2,d3) from 'comma.text' with  delimiter ',';              
ERROR:  missing data for column "d2"
CONTEXT:  COPY t, line 1: "a;b;c"

 \copy t(d1,d2,d3) from 'semicolon.text' with  delimiter ';' ;
--no error
cat comma.text
a,b,c
e,,f

cat semicolon.text
a;b;c
e;;f





pgsql-bugs by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: BUG #10297: yum - transaction check error
Next
From: David G Johnston
Date:
Subject: Re: pg import text data to not null table comma error but semicolon right