aws RDS s3 import command

0

I have a situation where the DB has a primary key field say "id" with an autoincrement or UUID auto generations field. I am using AWS RDS Postgres database. Options 1 (Preferred) - The CSV I want to import does not have the ID column and needs to ensure that the alignment of the columns can skip over the ID field. They are saying it does not match up and is not importing to the correct columns, Option 2 - The CSV has an existing ID field but they do not want to include that in the import so is there a way to exclude that column from importing? Overall I am looking forward to knowing if it is possible to tell which columns to use in the CSV to import or map to the table columns and if you can exclude columns or skip them.

已提問 2 年前檢視次數 131 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南