Skip site navigation (1) Skip section navigation (2)

Re: Copy from problem

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Eduardo Vázquez Rodríguez <evazquez(at)insys-corp(dot)com(dot)mx>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Copy from problem
Date: 2004-05-30 05:39:49
Message-ID: 1085895588.26732.1123.camel@linda (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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                    
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 HamplDate: 2004-05-30 10:30:14
Subject: Turn off Wal for bulk loaf input
Previous:From: Paul ThomasDate: 2004-05-29 08:58:56
Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group