Hi All,

I am trying to load a file into a database. The file in part looks like this.

10000,Citizens Bank Checking Account,0,TRUE
10001,Peoples Bank Operating Account,0,FALSE

I issue a copy command as follows and get the error as shown.

# copy myschema.tbl_account from '/dirname/Account.csv' with delimiter ',';
'RROR: copy: line 1, Bad boolean external representation 'TRUE
IPADB=#

What am I doing wrong?

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

On Thu, Oct 14, 2004 at 02:12:49PM -0400, Keith Worthington wrote:

I'd guess that there's a carriage return at the end of line 1. The
single quote at the beginning of the line supports this hypothesis:
that's exactly what would happen if 'TRUE\r' were printed.

You might need to run your data through a filter before importing
it into PostgreSQL. Some systems have a dos2unix program; you could
also use tr, sed, perl, awk, etc. to strip trailing carriage returns.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Michael Fuhr <mike (AT) fuhr (DOT) org> writes:
Looks like that to me too.

Alternatively, update to PG 7.4 or later. Since 7.4 COPY will attempt
to Do The Right Thing with files containing Windows-style newlines.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

It turns out there was a carrige return at the end of every line. Thasnk for
the help.

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings