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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-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

Browse pgsql-novice by date

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

Browse pgsql-sql by date

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