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/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
