Skip to content

Instantly share code, notes, and snippets.

@mjumbewu

mjumbewu/dump-csv

Created July 24, 2018 19:05
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mjumbewu/3daace7d8a98caba55032ba0bcb1e834 to your computer and use it in GitHub Desktop.
Save mjumbewu/3daace7d8a98caba55032ba0bcb1e834 to your computer and use it in GitHub Desktop.
Download ZIP
Shell script to dump a CSV file from a database table
Raw
dump-csv
#!/bin/sh -e
table=$1
psql -U $DBUSER -h $DBHOST -p $DBPORT $DBNAME -c \
"COPY (SELECT * FROM $table) TO STDOUT WITH CSV HEADER"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment