psqlcsv
v1.0.0
Published
Trivial psql CLI alternative that outputs proper CSV
Readme
psqlcsv
Small alternative to the default psql CLI. Outputs proper CSV
without using the COPY command (for Amazon Redshift compatibility)
Connection details should be supplied in env vars:
$ PGUSER=dbuser \
PGHOST=database.server.com \
PGPASSWORD=secretpassword \
PGDATABASE=mydb \
PGPORT=3211 \
psqlcsv 'SELECT id, json, messy_text FROM Data' > data.csv