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

Access import

From: "Marc Zandvliet" <marc(at)auroraworks(dot)com>
To: <pgsql-novice(at)hub(dot)org>
Subject: Access import
Date: 2000-08-30 18:43:19
Message-ID: LJEMIBPPIBGEBAAPNFGKEEINCAAA.marc@auroraworks.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

Any suggestions? This should be straight forward right?

Thanks for any assistance,

Marc


Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2000-08-30 18:47:04
Subject: Re: 7.0.2 regressions testing on Sparc running 2.5.1
Previous:From: ghaverlaDate: 2000-08-30 16:26:53
Subject: Re: 7.0.2 regressions testing on Sparc running 2.5.1

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