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
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 |
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 |