Re: problem with copy - Mailing list pgsql-general

From Anand Raman
Subject Re: problem with copy
Date
Msg-id 20010123094844.A24577@india-today.com
Whole thread Raw
In response to Re: problem with copy  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
thanx ton
I realized this a few minutes after i posted to the list..
Thanks
Anand

On Mon, Jan 22, 2001 at 10:46:34AM -0500, Tom Lane wrote:
>Anand Raman <araman@india-today.com> writes:
>> arttoday=# \copy artists from STDIN using delimiters '|' with null as '||';
>
>Er, don't you mean "with null as ''"?
>
>The above-given command will never think any input column is a null,
>since it won't parse '||' as a column value in the first place.
>
>            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: syntax of outer join in 7.1devel
Next
From: Tim Kientzle
Date:
Subject: Re: Troubles with performances