Linux command to export a PostgreSQL table from a remote server to a local CSV file.

export-postgresql-table.sh

psql -h hostname -U username -W -d database -t -A -F "," -c "SELECT * FROM table" > file.csv

# Explanation of the used options:
# -h Specifies the host name of the machine on which the server is running.
# -U Connect to the database as a specific user.
# -W Force psql to prompt for a password before connecting to a database.
# -d Specifies the name of the database to connect to.
# -t Turn off printing of column names and result row count footers, etc.
# -A Switches to unaligned output mode.
# -F Use separator as the field separator for unaligned output.
# -c Specifies that psql is to execute one command string, command, and then exit.