copy error

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