mjumbewu/dump-csv

Created July 24, 2018 19:05

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mjumbewu/3daace7d8a98caba55032ba0bcb1e834.js"></script>
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

	#!/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