after the query COPY objrts FROM 'C:\objrt00100.unl' (DELIMITER '|');
I do not know how to fight
ОШИБКА: лишние данные после содержимого последнего столбца CONTEXT: COPY objrts, строка 1: "11955|13124|I||93|0,0|0,0|0|0,0|0,0|0,0|0,0|0,0|0|0|2013-04-08 00:00:00|||"

  • Count the number of columns and the number of delimiters. It may be necessary to write NULL between empty ||. - msi

1 answer 1

Without the objrts structure , the exact answer cannot be given, but most likely you have too many elements in the string. Try removing some delimiters from the end.