Re: COPY: row is too big

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

2017-01-05 13:44 GMT+01:00 vod vos <vodvos@xxxxxxxx>:

I finally figured it out as follows:

1. modified the corresponding data type of the columns to the csv file

2. if null values existed, defined the data type to varchar. The null values cause problem too.

int, float, double can be null too - null needs same space (1bit) for all types

Regards

Pavel

 

so 1100 culumns work well now. 

This problem wasted me three days. I have lots of csv data to COPY.