postgres-json-export

Stream postgres query to output file in JSON format.

Install

npm install -g postgres-json-export

Example

postgresjson --query="select * from table" --config-file="./config.json"

Notes

1. Use --output param to define output file. If there is no output param, data will be saved to output.json in the current working folder.
2. Config file can be defined with --config-file argument. It must have connectionString property or you can pass connection string manually with --connection param.

License

MIT