From: | vod vos <vodvos(at)zoho(dot)com> |
---|---|
To: | "vod vos" <vodvos(at)zoho(dot)com> |
Cc: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: COPY: row is too big |
Date: | 2017-01-02 15:38:00 |
Message-ID: | 1595fd48444.ba3ec57e13739.3837934651947496063@zoho.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)zoho(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Colson | 2017-01-02 15:43:59 | Re: Queries on very big table |
Previous Message | Alfredo Palhares | 2017-01-02 15:20:44 | Cannot recover from backup on barman |