Re: Trouble with COPY and NULL

From: "Tom" <tom(at)minnesota(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trouble with COPY and NULL
Date: 2003-03-20 08:11:53
Message-ID: 3998.63.226.186.156.1048147913.squirrel@mail.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> You probably want to add a ; at the end of the command to actually
> switch to COPY mode.
>
> On Thu, Mar 20, 2003 at 01:48:26AM -0600, Thomas T. Thai wrote:
>> PostgreSQL 7.3.2
>>
>> tsearch=# COPY articles
>> tsearch-# FROM stdin WITH DELIMITERS '|' NULL AS '\null'
>> tsearch-# 3|Has Null in txtidx|\null|Michelle Morgan|'morgan':2B

Thanks. That did it. Can't believe that cost me almost an hour of time!

--
Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joel Rodrigues 2003-03-20 08:27:46 PostgreSQL downloads compressed with bzip2 instead of gzip ?
Previous Message Manfred Koizar 2003-03-20 07:58:28 Re: unexpected join results