Is there a way in the Rails Console to print a table of database contents?

ruby-on-rails ruby rails-console
Zack Shapiro picture Zack Shapiro · May 5, 2012 · Viewed 13.9k times · Source

I'm looking for a clean and simple way to print in the Rails Console the contents of my 5 row database with 2 columns.

Any ideas? I Googled around but didn't find much.

Answer

Amokrane Chentir picture Amokrane Chentir · May 5, 2012

I think you should first use the hirb gem which provides a very pleasant way to print your tables columns.

  1. Install hirb gem: gem install hirb
  2. Add this gem to your project's Gemfile: gem 'hirb'
  3. Go to your project's root folder and run Rails console: rails c

  4. Enable hirb in the console:

    require 'hirb'
Hirb.enable

If you want to limit the number of rows to display, you can do:

Model.limit(n)

For instance:

User.limit(5)

You can also specify the fields that you want to display using select:

User.select("name, email").limit(5)

Related questions

Write to rails console

When I want to try or debug smthing I run rails console and do some stuff there. I can print some text or variables from code by raising exception with raise "blablabla". Question: How I can just write to rails …

Read More
Devise password reset from Rails console

While running an app how do you select a user by email address and then set the password manually within rails console for Devise? Also, where would I go to review documentation to cover more details in this regard to …

Read More
Rails Console find users by array of ids

So I have an array of user ids. Is there a way in rails console to query all of these user's with the array something like ids = [1, 2, 3, 4] users = User.find(ids) and have it return all 4 users?

Read More