importing data

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