Trouble with COPY and NULL

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Trouble with COPY and NULL
Date: 2003-03-20 07:48:26
Message-ID: Pine.NEB.4.44.0303200145580.12905-100000@ns01.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
'michell':1B|This row has a NULL in the title_fts column so we can test
concatenation.|'a':4C 'in':6C 'so':11C 'we':12C 'can':13C 'fts':9C
'has':3C 'row':2C 'the':7C 'null':5C 'test':14C 'this':1C 'titl':8C
'column':10C 'concaten':15C
Invalid command \null|Michelle. Try \? for help.

--

It seems to think that \null in the data is a command because of the
backslash. Am I missign something?

--
Thomas T. Thai

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-03-20 07:56:25 Re: Trouble with COPY and NULL
Previous Message Bruce Momjian 2003-03-20 07:02:29 Re: ALTER SEQUENCE