How to get tables from postgresql in heroku?

Question

I have windows, git bash,pg-admin 3, a Heroku app with a PostgreSQL database,Is there any git bash command to get the db and tables name? because i forgot the names and i can not make any query (select * from (?) )

I have tried:
\list command in git bash, but does not exist. Looking from Heroku web but no success.
Is there any way to get the names?

select * from information_schema.tables postgresql.org/docs/current/static/information-schema.html — user330315
– user330315, Commented Jul 24, 2014 at 16:51
wow, thx, i got all info there! now i know the names of my tables! (not from git bash, using heroku webpage). can i see the columns of that tables? — Jona Santana
– Jona Santana, Commented Jul 24, 2014 at 17:17

khampson · Accepted Answer · 2014-07-25 00:48:11Z

6

git bash is simply a Cygwin-esque bash emulator that allows git to be run under Windows. Just as there is no native bash command to interact with Postgres, neither would there be one for git bash. You would need a separate program in either case.

Heroku has a special version of the regular Postgres psql called pg:psql which will let you run queries on the tables in your Heroku Postgres instance.

So you could run, for example:

SELECT * FROM users ORDER BY id;

More info on this tool is available here:

https://devcenter.heroku.com/articles/heroku-postgresql#pg-psql

More info on Postgres psql here:

http://www.postgresql.org/docs/9.3/static/app-psql.html

answered Jul 25, 2014 at 0:48

khampson

15.5k4 gold badges45 silver badges44 bronze badges

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

3 Comments

Jona Santana Over a year ago

Ok!that was the reason of several error messages. thanks so much!!

khampson Over a year ago

Sure, no problem. Since it appears this answered your question, please accept my answer. More details on how to do that (among other info) can be found here: stackoverflow.com/tour

miso Over a year ago

they changed command slightly in 2020, open cmd in windows and type heroku pg:psql -a <app_name> and then you can type SQL

Smart Manoj · Accepted Answer · 2020-03-23 12:58:26Z

4

As mentioned by the user

heroku pg:psql

select * from information_schema.tables;

answered Mar 23, 2020 at 12:58

Smart Manoj

6,0836 gold badges45 silver badges66 bronze badges

Collectives™ on Stack Overflow

How to get tables from postgresql in heroku?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related