Postgres Pro
Downloads
Home   >   mailing lists

Thread: copy error

copy error

From
"Keith Worthington"
Date:
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

Re: copy error

From
Michael Fuhr
Date:
On Thu, Oct 14, 2004 at 02:12:49PM -0400, Keith Worthington wrote:

> 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=#

I'd guess that there's a carriage return at the end of line 1.  The
single quote at the beginning of the line supports this hypothesis:
that's exactly what would happen if 'TRUE\r' were printed.

You might need to run your data through a filter before importing
it into PostgreSQL.  Some systems have a dos2unix program; you could
also use tr, sed, perl, awk, etc. to strip trailing carriage returns.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Re: copy error

From
Tom Lane
Date:
Michael Fuhr <mike@fuhr.org> writes:
> I'd guess that there's a carriage return at the end of line 1.

Looks like that to me too.

> You might need to run your data through a filter before importing
> it into PostgreSQL.  Some systems have a dos2unix program; you could
> also use tr, sed, perl, awk, etc. to strip trailing carriage returns.

Alternatively, update to PG 7.4 or later.  Since 7.4 COPY will attempt
to Do The Right Thing with files containing Windows-style newlines.

            regards, tom lane

Re: copy error

From
"Keith Worthington"
Date:
> Michael Fuhr <mike@fuhr.org> writes:
> > I'd guess that there's a carriage return at the end of line 1.
>
> Looks like that to me too.
>
> > You might need to run your data through a filter before importing
> > it into PostgreSQL.  Some systems have a dos2unix program; you could
> > also use tr, sed, perl, awk, etc. to strip trailing carriage returns.
>
> Alternatively, update to PG 7.4 or later.  Since 7.4 COPY will
> attempt to Do The Right Thing with files containing Windows-style newlines.
>
>             regards, tom lane

It turns out there was a carrige return at the end of every line.  Thasnk for
the help.

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com