Received: from hub.org.org (localhost [127.0.0.1])
	by hub.org (8.10.1/8.11.0) with SMTP id e9OMUhN65144
	for <pgsql-novice@hub.org>; Tue, 24 Oct 2000 18:30:45 -0400 (EDT)
	(envelope-from pgsql-novice-owner@hub.org)
Received: from nts1.rtp.epa.gov (nts1.rtp.epa.gov [134.67.208.208])
	by hub.org (8.10.1/8.11.0) with ESMTP id e9OKe7N52626;
	Tue, 24 Oct 2000 16:40:07 -0400 (EDT)
	(envelope-from volpe.mark@epamail.epa.gov)
Received: from epamail.epa.gov (IDENT:mvs@wolfpack.rtpnc.epa.gov
	[134.67.139.59])
	by nts1.rtp.epa.gov (8.9.3/8.9.3) with ESMTP id QAA03409;
	Tue, 24 Oct 2000 16:44:13 -0400 (EDT)
Message-ID: <39F5F39A.781DB54D@epamail.epa.gov>
Date: Tue, 24 Oct 2000 16:39:54 -0400
From: Mark Volpe <volpe.mark@epamail.epa.gov>
X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.14-15mdk i586)
X-Accept-Language: en
MIME-Version: 1.0
To: Sandis Jerics <sandis@mediaparks.lv>
CC: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [SQL] Re: NULL
References: <20001024155506.A775@styx> <2896.001024@mediaparks.lv>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200010/140
X-Sequence-Number: 1023

\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