файл csv в postgresql, на php

Проблема в цикле как я понимаю, может из за того что колона массив?

<?php

if(isset($_POST['submitcsv']) and $_FILES)
{

  require ('../con/head_loc.php');

$file = fopen('uploades/Insert.csv', 'r');

          while ( ( $line = fgetcsv( $file ) ) !== FALSE) 
          {
          $rec = "INSERT INTO pos (id, serial, mid, tid, pos_type, mcc, merchant_name, merchant_tax_number, merchant_address, pos_owner_id, payment_system_id) 
          VALUES ('" . $file[0] . "', '" . $file[1] . "', '" . $file[2] . "', '" . $file[3] . "', '" . $file[4] . "', '" . $file[5] . "', '" . $file[6] . "', '" . $file[7] . "', '" . $file[8] . "', '" . $file[9] . "')";
          }
          fclose( $file );

      
}
?>

Но sql через получается:

COPY pos (serial, mid, tid, pos_type, mcc, merchant_name, merchant_tax_number, merchant_address, pos_owner_id, payment_system_id) FROM '/home/comp/Рабочий стол/work elements/Insert.csv' DELIMITER ',' CSV HEADER;

Ну вот и содержания файла:

"serial","mid","tid","pos_type","mcc","merchant_name","merchant_number","merchant_address","pos_id","payment_id"
44103,442239,44113,"ZA 220",2323,"MN SX",33333,"27 Marks str.",1,1
44817,447115,447115,"zA 250",2323,"SIXTY Sxx",3332222,"29 ABss str.",1,1
444034,444132,447132,"za 220",2323,"SIXTY Q",33333222,"Micro 4 dist.N2",1,1
44484980,447133,447133,"za 250",2323,"SIXTY R",333333332,"4/3 Peace circle",1,1

В базе данных serial уникальный


Ответы (0 шт):