CODEWITHSUNDEEP
ruby-on-railspostgresqlherokuruby-on-rails-4
chaitanya90
chaitanya90

Reputation: 707

Heroku database: How can I view my table entries in deployed herokuapp

I would like to know is their a way to look into our data entries which is made to the postgresql database present in Heroku. I am using Rails 4 and I have tried heroku run rails console it works fine, but everything is all messed up.

And while using heroku pg:psql as it was suggested to me as an answer below

psql is not recognised as an internal or external command, operable file or batch file

What is wrong with it?. thank you for helping.

Upvotes: 1

Views: 1133

Answers (3)

Johno Scott
Johno Scott

Reputation: 1740

You must (according to heroku documentation) have PostgreSQL installed on your system to use

heroku pg:psql

The docs has links to installers for common platforms.

I am using Windows and this fixed the problem for me once I permanently added the location of psql.exe to my system path :

setx path "%path%;C:\Program Files (x86)\PostgreSQL\9.4\bin"

Upvotes: 2

chaitanya90
chaitanya90

Reputation: 707

Well the solution to this problem is to move to that specific path where the psql.exe is present. For example, C:\Program Files\PosrtgreSQL\9.3\bin and then it can be executed by the following:

heroku pg:psql --app app_name

this will get this working.

Upvotes: 0

Alex
Alex

Reputation: 8539

Do you want to open the Postgre terminal? If so, just type:

Heroku pg:psql

In your terminal to enter your database. Docs here.

Upvotes: 0

Related Questions