Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] COPY: row is too big - Mailing list pgsql-general

From vod vos
Subject Re: [GENERAL] COPY: row is too big
Date
Msg-id 1595fd48444.ba3ec57e13739.3837934651947496063@zoho.com
Whole thread Raw
In response to [GENERAL] COPY: row is too big  (vod vos <vodvos@zoho.com>)
List pgsql-general
Tree view
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@zoho.com> 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.

pgsql-general by date:

Previous
From: Alfredo Palhares
Date:
Subject: [GENERAL] Cannot recover from backup on barman
Next
From: Andy Colson
Date:
Subject: Re: [GENERAL] Queries on very big table