Want to upsert data from CSV file to existing PostgreSQL table via command line on MacOS?
Using pg-cmd, you can upsert(merge) CSV/TSV/TXT data to PostgreSQL table easily and fast, no need to program.
Here you can download pg-cmd MacOS version.
No need to install PostgreSQL client library.
Convenient to deploy to cloud. No need to run installation file, just uncompress and run, immediately.
Upsert/Merge CSV/TSV/TXT data into PostgreSQL table via command line on MacOS
1. In interactive mode:
pg-cmd> load loadtype=upsert
> updatekey=id
> table=media_messages
> datafile=/Users/pan/Documents/media_messages.csv
> delimiter=,
> quote="
> header=y;
2. In batch mode:
pg-cmd dsn="pan:withdata@192.168.0.102/test" task=load loadtype=upsert updatekey=id table=media_messages datafile=/Users/pan/Documents/media_messages.csv delimiter=, quote=" header=y quit=y
“loadtype=upsert” will update row in table if “updatekey” id exists, or insert new row.
See parameters detail.