Re: COPY: row is too big

Rob Sargent <robjsargent@xxxxxxxxx> · Thu, 5 Jan 2017 09:31:24 -0700



    On 01/05/2017 05:44 AM, vod vos wrote:

    
        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.

        
        so 1100 culumns work well now. 

        
        This problem wasted me three days. I have lots of csv data
          to COPY.

        
    Yes, you cost yourself a lot of time by not showing the original
    table definition into which you were trying insert data.