SqlCsv

Create a CSV export from a SQL query.

Add this line to your application's Gemfile:

gem 'sql_csv'

And then execute:

$ bundle install

Or install it yourself as:

$ gem install sql_csv

An executable sql2csv is installed with the gem.

Write an SQL command to stdin and set DATABASE_URL to configure connection. CSV output will be written to stdout.

echo "select * from users" | DATABASE_URL='postgresql://user:password@host:1234/database' sql2csv > users.csv

The gem is available as open source under the terms of the MIT License.