Home>

Isn't it possible to remove (ignore?) CSV unnecessary items with the PostgreSQL COPY command?
I would like to ignore the second, fourth, and fifth items in the CSV item because they are unnecessary.
(Imaginarily)
>COPY table (ID, FILLER, CITY, FILLER, FILLER, ZIP_CODE) FROM XXXXX.csv

Even if you search elsewhere, remove unnecessary items from CSV first ...
Create a dummy table, import CSV, then INSERT only necessary items.