psqlcsv

    1.0.0 • Public • Published

    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
    

    Keywords

    Install

    npm i psqlcsv

    DownloadsWeekly Downloads

    0

    Version

    1.0.0

    License

    MIT

    Unpacked Size

    1.46 kB

    Total Files

    3

    Last publish

    Collaborators

    • gpittarelli