From: Mark Volpe <volpe.mark@epamail.epa.gov>
To: Sandis Jerics <sandis@mediaparks.lv>
Cc: pgsql-novice@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Re: NULL
Date: Tue, 24 Oct 2000 16:39:54 -0400
Message-ID: <39F5F39A.781DB54D@epamail.epa.gov> (raw)
References: <20001024155506.A775@styx>
<2896.001024@mediaparks.lv>
\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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: volpe.mark@epamail.epa.gov, sandis@mediaparks.lv, pgsql-novice@postgresql.org
Subject: Re: [SQL] Re: NULL
In-Reply-To: <39F5F39A.781DB54D@epamail.epa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox