Horton
Menu

Re: Trouble with COPY and NULL

Thomas T. Thai <tom@minnesota.com>

View thread
From: "Tom" <tom@minnesota.com>
To: <pgsql-general@postgresql.org>
Date: 2003-03-20T08:11:53Z
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