Skip to content

Instantly share code, notes, and snippets.

@sebastiaojuniordev

sebastiaojuniordev/export-postgresql-table.sh

Forked from stefanthoss/export-postgresql-table.sh
Created March 10, 2022 16:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sebastiaojuniordev/c5769d075bd40d3002f820525dd6e2d7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sebastiaojuniordev/c5769d075bd40d3002f820525dd6e2d7 to your computer and use it in GitHub Desktop.
Download ZIP
Linux command to export a PostgreSQL table from a remote server to a local CSV file.
Raw
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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment