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
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,
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2000-08-30 18:47:04|
|Subject: Re: 7.0.2 regressions testing on Sparc running 2.5.1 |
|Previous:||From: ghaverla||Date: 2000-08-30 16:26:53|
|Subject: Re: 7.0.2 regressions testing on Sparc running 2.5.1|