Re: importing data

From: Chris <dmagick(at)gmail(dot)com>
To: Craig White <craigwhite(at)azapple(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: importing data
Date: 2006-06-01 02:20:12
Message-ID: 447E4EDC.1060209@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2006-06-01 02:48:19 Re: Moving Postgres Database
Previous Message Chris 2006-06-01 02:18:07 Re: Moving Postgres Database