How to export table from heroku production database locally to excel from console using Ruby?

ruby ruby-on-rails-3 excel export-to-excel
tomekfranek picture tomekfranek · Mar 22, 2013 · Viewed 7k times · Source

I know how to export table in Rails to formated Excel file: http://railscasts.com/episodes/362-exporting-csv-and-excel

But how to do that from console.

Answer

algometrix picture algometrix · Jul 11, 2014

Connect to your Heroku database by using 

heroku pg:psql

Then run the sql command to get the csv file e.g. 

\copy (SELECT * FROM users) TO dump.csv CSV DELIMITER ','

Use \q to exit.

After executing the commands dump.csv would have been created in your local environment

Related questions

Writing to excel files in ruby using roo gem

I am parsing Excel and Excelx file using Roo gem. But I am not sure how to write in those files. set_value(row, column, text) method is not working. Code @oo = Excelx.new('tes.xlsx') @oo.default_sheet = @oo.…

Read More
Setting Excel column widths correctly when adding to spreadsheet via Axlsx

I'm trying to format my report and making sure the columns have a correct width and I can't seem to make it happen with auto_width. With this code, this is the kind of report I get . Notice the space …

Read More
How to get a random number in Ruby

How do I generate a random number between 0 and n?

Read More