Export data from PostgreSQL to CSV via command line on Windows

Want to export PostgreSQL data to CSV file via command line on Windows? Using pg-cmd, you can unload PostgreSQL data to CSV/TSV/TXT easily and fast, no need to program. Here you can download pg-cmd Windows version. No need to install PostgreSQL client library. Convenient to deploy to cloud. ... Read more

Upsert data from CSV to PostgreSQL table via command line on Linux

Want to upsert data from CSV file to existing PostgreSQL table via command line on Linux (Ubuntu/RedHat/CentOS…)? 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 Linux version. No need to install ... Read more

Upsert data from CSV to PostgreSQL table via command line on Windows

Want to upsert data from CSV file to existing PostgreSQL table via command line on Windows? 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 Windows version. No need to install PostgreSQL client ... Read more

Append CSV data to PostgreSQL table via command line on Macos

Want to append the data from CSV file to the existing PostgreSQL table via command line on MacOS? Using pg-cmd, you can append CSV/TSV/TXT data into existing PostgreSQL table easily and fast, no need to program. Here you can download pg-cmd MacOS version. No need to install PostgreSQL client ... Read more