Trouble with COPY and NULL - Mailing list pgsql-general

From Thomas T. Thai
Subject Trouble with COPY and NULL
Date
Msg-id Pine.NEB.4.44.0303200145580.12905-100000@ns01.minnesota.com
Whole thread Raw
Responses Re: Trouble with COPY and NULL  (Martijn van Oosterhout <kleptog@svana.org>)
List 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




pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Very stupid backup I made
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Trouble with COPY and NULL