copy error

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: copy error
Date: 2004-10-14 18:12:49
Message-ID: 20041014181249.M50362@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alexander Pucher 2004-10-14 19:46:33 Looking for correct SQL
Previous Message Kumar S 2004-10-14 15:18:42 Two table joins