How do you access your heroku database (specifically postgres)?

Question

When I am developing locally, I'll just run a

rails c

and I can fire of queries at the console.

However, how can I query and access my postgres database that is up on heroku?

derekyau · Accepted Answer · 2014-05-07 00:07:29Z

3

You can run heroku run rails c --app <appname>. I will also add, if you want to view your database, you can make use of PG Commander https://eggerapps.at/pgcommander/ which actually automatically parses all the credentials out for you.

If you want to do this, run heroku config --app <appname> and then copy the DATABASE_URL. After you've done this, create a new favourite in your PG Commander and you'll see that it has already automatically filled in all the credentials based on what was in your clipboard.

answered May 7, 2014 at 0:07

derekyau

2,9461 gold badge18 silver badges14 bronze badges

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

3 Comments

derekyau Over a year ago

the --app <appname> is optional in case you have multiple apps attached

chris P Over a year ago

Thanks! That begs me to ask... if I can do this... why am I not able to run 'heroku run psql databasename' like I can locally?

derekyau Over a year ago

well you can actually heroku pg:psql as per devcenter.heroku.com/articles/heroku-postgresql

Collectives™ on Stack Overflow

How do you access your heroku database (specifically postgres)?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related