Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group