Home > mailing lists

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

From	vod vos
Subject	[GENERAL] COPY: row is too big
Date	January 2, 2017 17:11:14
Msg-id	1595ee04ac3.da3f53a012572.7823379978959893678@zoho.com Whole thread Raw
Responses	Re: [GENERAL] COPY: row is too big (John McKown <john.archie.mckown@gmail.com>) Re: [GENERAL] COPY: row is too big (Adrian Klaver <adrian.klaver@aklaver.com>) Re: [GENERAL] COPY: row is too big (vod vos <vodvos@zoho.com>) Re: [GENERAL] COPY: row is too big (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

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: amul sul
Date: 02 January 2017, 16:42:28
Subject: Re: [GENERAL] Difficulty modelling sales taxes

From: Job
Date: 02 January 2017, 17:23:00
Subject: [GENERAL] Queries on very big table