Rails console and postgres

Question

I'm trying to figure out which database i'm using in the rails console, i understand it says Loading development environment (Rails 4.2.0), so i'm presuming its whatever database i listed in development in gemfile but i'm not so sure, is there a way of checking this inside the console?, or is it better to just use the psql command line with raw sql, because from what i see, active record queries don't work with the pg command line.

Active record in postgres console.

psql (9.4.0, server 9.2.4)
Type "help" for help.

spencerlong=# User.all
spencerlong-#

Better yet, a console with postgres AND Active_record capabilities.

active record queries don't work with the pg command line yeah, pgsql is no ruby — apneadiving
– apneadiving, Commented Apr 21, 2015 at 8:23
granted yes, so do you know of a way to run postgres database in rails console, (for querying active record) or is it whatever you listed in gemfile under given environment., thats what you'll use. — Spencer Hire
– Spencer Hire, Commented Apr 21, 2015 at 8:25

user3118220 · Accepted Answer · 2015-04-21 08:35:37Z

1

Write a below command in rails console to get database name

Rails.configuration.database_configuration["development"]["database"]

edited Apr 21, 2015 at 8:35

answered Apr 21, 2015 at 8:24

user3118220

1,46812 silver badges16 bronze badges

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

2 Comments

Spencer Hire Over a year ago

NoMethodError: undefined method `new' for Rails::Configuration:Module is what i get from that.

user3118220 Over a year ago

I just update my post, please see, I have rails 4.0 version, it works for me

Collectives™ on Stack Overflow

Rails console and postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related