On Mon, 2004-05-24 at 18:54, Eduardo Vázquez Rodríguez wrote:
> When I issue the following command
> copy public."Example" from '/home/postgres/abc.txt';
> The following error appears
> ERROR: missing data for column "Email"
> CONTEXT: COPY Prueba, line 2: "Jessie Rodriguez Santa Anna "
> My question is how can I insert a null value into the field email,and that
> copy from continue copying the next lines?
Null values are represented by \N (or by some other string specified in
the COPY command - see its documentation).
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
"Do all things without murmurings and disputings;
that ye may be blameless and harmless, the sons of
God, without rebuke, in the midst of a crooked and
perverse nation, among whom ye shine as lights in the
world." Philippians 2:14,15
In response to
pgsql-novice by date
|Next:||From: Martin Hampl||Date: 2004-05-30 10:30:14|
|Subject: Turn off Wal for bulk loaf input|
|Previous:||From: Paul Thomas||Date: 2004-05-29 08:58:56|
|Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?|