|
Is this ERROR thrown for all the rows ?
Try the following. select max(length(column_name)) from table_name; It seems that some value is bigger than the define size. > Date: Sun, 5 Feb 2012 21:14:40 -0800 > From: w_ward_w@xxxxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: Error while importing CSV file > > OK that problem solved > Thanks so much > > but I had another problem > > *ERROR: value too long for type character varying(100)* > > although in the original file it was varying(25) only !! > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5459345.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general |
