copy error - Mailing list pgsql-novice

From Keith Worthington
Subject copy error
Date
Msg-id 20041014181249.M50362@narrowpathinc.com
Whole thread Raw
Responses Re: copy error  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Kumar S
Date:
Subject: Two table joins
Next
From: Alexander Pucher
Date:
Subject: Looking for correct SQL