How to insert CSV data into PostgreSQL database (remote database )

January 1, 2024 by Tarik

psql’s \copy (note the backslash) lets you copy to/from remote databases and does not require superuser privileges.

psql \
  -h $hostname -d $dbname -U $username \
  -c "\copy mytable (column1, column2)  from '/path/to/local/file.csv' with delimiter as ','"

https://www.postgresql.org/docs/current/sql-copy.html