Now I am confused about I can create 1100 columns in a table in postgresql, but I can't copy 1100 values into the table. And I really dont want to split the csv file to pieces to avoid mistakes after this action.
I create a table with 1100 columns with data type of varchar, and hope the COPY command will auto transfer the csv data that contains some character and date, most of which are numeric.
I use the command: COPY rius FROM "/var/www/test/test.csv" WITH DELIMITER ';' ;
Then it shows:
ERROR: row is too big: size 11808, maximum size 8160