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

Re: [SQL] Re: NULL

From: Mark Volpe <volpe(dot)mark(at)epamail(dot)epa(dot)gov>
To: Sandis Jerics <sandis(at)mediaparks(dot)lv>
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Re: NULL
Date: 2000-10-24 20:39:54
Message-ID: 39F5F39A.781DB54D@epamail.epa.gov (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-sql
\N is normally used to represent NULL in a text file, however
you can change that to another string (or an empty string) using
COPY FROM ... WITH NULL AS

Mark

Sandis Jerics wrote:
> 
> Hello,
> 
> how must i write a NULL value in a text file for the \copy command to
> understand it?
> NULL, \0 doesnt work..
> 
> how must i write a boolean value in a text file for the \copy command to
> understand it?
> t doesnt work, however in a file written by /copy command it looks as
> t or f ..
> 
> tried to search archives, but it seems deadly slow...
> 
> Thanks in advance,
> sandis

In response to

  • Re: NULL at 2000-10-24 18:31:27 from Sandis Jerics

pgsql-novice by date

Next:From: Tom LaneDate: 2000-10-24 22:51:03
Subject: Re: knowing which columns have beend UPDATEd inside a TRIGGER?
Previous:From: Sandis JericsDate: 2000-10-24 18:31:27
Subject: Re: NULL

pgsql-sql by date

Next:From: Albert REINERDate: 2000-10-24 21:15:10
Subject: Re: help on creating table
Previous:From: Tubagus NizomiDate: 2000-10-24 19:06:58
Subject: Error in Extrack Database

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