Search code examples
postgresqltalend

I can't map correctly an Excel file to postgreSQL using Talend. the id cannot be forced from the input file

I have a simple xls file (excel), I have a column N_ENR which contains numeric values (the primary keys from a table).

I'm using Talend.

Now, I want to save all the records into a potgreSQL table (table client), the problem is that my output table (table client) generates new ids, the other columns are mapped correctly (address, date, phoneNumber, ...).

I changed the type of the primary key (id column) to serial, still didn't work.

Any suggestions ? Thank you.

Solution

  • If you are able to change the type of the PK column change it to 'int' and then map your source ID to that column.