Show data in table from Rails Console for PostgreSQL

Question

I find something like this: Rails: How to list database tables/objects using the Rails console?

This line is fine:

ActiveRecord::Base.connection.tables

and returns all tables

but

ActiveRecord::Base.connection.table_structure("users")

generate error:

ActiveRecord::Base.connection.table_structure("projects")

I think that

table_structure

is not Postgres method.

How can I list all data from the table in Rails console for Postgres database?

house9 · Accepted Answer · 2014-09-14 16:06:12Z

13

You can get this information from postgres directly from the command line

psql your_development_database -c "\d"
-- lists all database tables

psql your_development_database -c "\d users"
-- lists all columns for a table; 'users' in this case

If you want to look at Model attributes in the rails console

User.new
User.new.inspect

# or install the awesome_print gem for better output
ap User.new

answered Sep 14, 2014 at 16:06

house9

20.7k9 gold badges57 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

grooble Over a year ago

don't forget: \q to exit the psql console. just saved you a search ;)

house9 Over a year ago

@grooble - the above is using the -c option so it executes the command but does not enter an interactive psql session, no need to \q in that case

Collectives™ on Stack Overflow

Show data in table from Rails Console for PostgreSQL

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related