Skip site navigation (1) Skip section navigation (2)

Re: Access import

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc Zandvliet" <marc(at)auroraworks(dot)com>
Cc: pgsql-novice(at)hub(dot)org
Subject: Re: Access import
Date: 2000-08-30 18:53:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
"Marc Zandvliet" <marc(at)auroraworks(dot)com> writes:
> I'm trying to import a small Access db into a linux-based psql database via
> a delimited text file. I've set up the table to reflect the fields etc. The
> last field of the database is boolean which Access exports as 0 or 1. When I
> try to import I get this:

> mydb=> copy new_table from '/tmp/exported.txt' using delimiters '|';
> 'RROR:  Bad boolean external representation '1
> mydb=>

> I've checked the source text file and the last field doesn't have the '
> before the 1.

Looks to me like your source text file is probably stored with DOS
newlines, ie CR/LF.  COPY is expecting Unix newlines (LF only) and
treats the CR characters as part of the data.  The boolean input
converter doesn't like garbage characters in its input data, and when
it complains, the CR is included in the error message, causing the
overstrike behavior you show.  The message is really

ERROR:  Bad boolean external representation '1<CR>'

Convert the file to Unix newline convention and you should be OK...

			regards, tom lane

In response to


pgsql-novice by date

Next:From: radixDate: 2000-08-30 22:18:30
Subject: sql with postgresql beginner
Previous:From: Tom LaneDate: 2000-08-30 18:47:04
Subject: Re: 7.0.2 regressions testing on Sparc running 2.5.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group