Re: importing data - Mailing list pgsql-general

From Greg Stark
Subject Re: importing data
Date
Msg-id 87bqtdihx6.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: importing data  (Chris <dmagick@gmail.com>)
List pgsql-general
Chris <dmagick@gmail.com> writes:

> Craig White wrote:
> > I am getting an error when I import, invalid input syntax for type
> > boolean - which is empty. Is there any way around this of must I
> > necessarily have \N ?

You could try with:

COPY ... WITH NULL AS ''


--
greg

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Moving Postgres Database
Next
From: "Philippe Lang"
Date:
Subject: Re: PGSQL 7.4 -> 8.1 migration & performance problem