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
What am I doing wrong?
99main Internet Services http://www.99main.com
pgsql-novice by date
|Next:||From: Alexander Pucher||Date: 2004-10-14 19:46:33|
|Subject: Looking for correct SQL|
|Previous:||From: Kumar S||Date: 2004-10-14 15:18:42|
|Subject: Two table joins|