Thread: importing data

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 ?

Craig

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 ?

They will have to be changed to nulls - the boolean type only allows
true, false or null:

http://www.postgresql.org/docs/8.1/static/datatype-boolean.html

--
Postgresql & php tutorials
http://www.designmagick.com/

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