Re: Trouble with COPY and NULL - Mailing list pgsql-general

From Tom
Subject Re: Trouble with COPY and NULL
Date
Msg-id 3998.63.226.186.156.1048147913.squirrel@mail.minnesota.com
Whole thread Raw
In response to Re: Trouble with COPY and NULL  (Martijn van Oosterhout <kleptog@svana.org>)
List 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



pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: unexpected join results
Next
From: "Thomas T. Thai"
Date:
Subject: CASE WHEN ERROR: Void value