Thread: Re: NULL

Re: NULL

From
Sandis Jerics
Date:
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



Re: [SQL] Re: NULL

From
Mark Volpe
Date:
\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