Postgres Pro
Downloads
Home   >   mailing lists

Re: error loading data with copy - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: error loading data with copy
Date
Msg-id 20041121084341.GA67194@winnie.fuhr.org
Whole thread Raw
In response to error loading data with copy  (Fred Wohlfert <fredwohlfert@ehbmail.com>)
List pgsql-admin
Tree view 
On Wed, Nov 17, 2004 at 11:43:05AM -0500, Fred Wohlfert wrote:

> *ham-existing=# \copy invst from '/home/fmwdba/transcoma' using
> delimiters ','
> \.
> ERROR:  value too long for type character(7)
> CONTEXT:  COPY invst, line 1, column stknum: "'0020338'"

Looks like the stknum values in the file have extraneous single
quotes.

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

pgsql-admin by date:

Previous
From: "Lane Rollins"
Date:
Subject: How to repair 'could not access status of transaction '
Next
From: "Di Croce, Tony"
Date:
Subject: Stamping rows...