Re: COPY: row is too big

[vod vos <vodvos@xxxxxxxx>]

The most of the data type are text or varhcar, and I use:

COPY rius FROM "/var/www/test/aa.csv" WITH DELIMITER ';' ;

And some the values in the csv file contain nulls, do this null values matter? 

Thanks.

---- On 星期一, 02 一月 2017 03:11:14 -0800 vod vos <vodvos@xxxxxxxx> wrote ----

Hi everyone,

My postgresql is 9.61.

When I copy data from csv file, a very long values for many columns (about 1100 columns). The errors appears:

ERROR:  row is too big: size 11808, maximum size 8160CONTEXT: 

COPY rius, line 2

rius is the table.

I have searched the mailing list, but seems no solutions founded.

Thanks.