Appending imported data in Postgres This is what I typically use to import csv data into my postgres database..

\COPY master_list FROM '/root/raw/file.txt' DELIMITER ',' CSV;


Usually it's into a blank table, but in this case, I need to append the data into a table with existing data.

Will that same command suffice, or should I make changes since it's an append?
Try it and see.

You'll find that it works perfectly.

Now, if you want to insert data ignoring duplicates, that's another problem entirely.