Re: problem with copy

From: Anand Raman <araman(at)india-today(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: problem with copy
Date: 2001-01-23 04:18:44
Message-ID: 20010123094844.A24577@india-today.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)india-today(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guy Fraser 2001-01-23 04:23:54 Re: Dropping a column
Previous Message Tim Kientzle 2001-01-23 04:05:57 Re: Troubles with performances