Re: Trouble with COPY and NULL

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
> '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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> IT is not something like pizza that you order in at one o'clock in
> the morning. - John Loebenstein, St George CIO