psqlcsv
Trivial psql CLI alternative that outputs proper CSV
Last updated 2 years ago by gpittarelli .
MIT · Repository · Bugs · Original npm · Tarball · package.json
$ cnpm install psqlcsv 
SYNC missed versions from official npm registry.

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

Current Tags

  • 1.0.0                                ...           latest (2 years ago)

1 Versions

  • 1.0.0                                ...           2 years ago
Maintainers (1)
Downloads
Today 0
This Week 0
This Month 1
Last Day 0
Last Week 1
Last Month 1
Dependencies (3)
Dev Dependencies (0)
None
Dependents (0)
None

Copyright 2014 - 2016 © taobao.org |