Re: importing data - Mailing list pgsql-general

From Chris
Subject Re: importing data
Date
Msg-id 447E4EDC.1060209@gmail.com
Whole thread Raw
In response to importing data  (Craig White <craigwhite@azapple.com>)
Responses Re: importing data
List pgsql-general
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/

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Moving Postgres Database
Next
From: Jim Nasby
Date:
Subject: Re: Moving Postgres Database