Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 01 Jun 2006 12:20:12 +1000
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/
- References:
- importing data
- From: Craig White
- importing data
- Prev by Date: Re: Moving Postgres Database
- Next by Date: Re: Moving Postgres Database
- Previous by thread: importing data
- Next by thread: command line
- Indexes: