Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: [GENERAL] COPY: row is too big
Date
Msg-id CAFj8pRB0J=Ln97yQCY8tq4DK7GO5jOzH8BvXXHS7UZERN0ApAg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] COPY: row is too big  (vod vos <vodvos@zoho.com>)
List pgsql-general
Tree view


2017-01-05 13:44 GMT+01:00 vod vos <vodvos@zoho.com>:
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.



pgsql-general by date:

Previous
From: marcin kowalski
Date:
Subject: Re: [GENERAL] vacuum of empty table slows down as database tablecount grows
Next
From: junior
Date:
Subject: Re: [GENERAL] Queries on very big table