Re: COPY: row is too big

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 16:21:29
Message-ID: 17512.1483374089@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

vod vos <vodvos(at)zoho(dot)com> writes:
> 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 8160

You need to rethink your table schema so you have fewer columns.
Perhaps you can combine some of them into arrays, for example.
JSON might be a useful option, too.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-01-02 16:27:30 Re: Difficulty modelling sales taxes
Previous Message David G. Johnston 2017-01-02 16:20:12 Re: Difficulty modelling sales taxes