Where can I see my Postgres database?

anitabenites201 · January 29, 2020, 5:46pm

Once postgresql is correctly installed, where can I see my database? thanks

NobbZ · January 29, 2020, 5:51pm

You can either use psql command line tool and use PostgreSQL commands and SQL in it, or you can install some graphical tool, whatever you prefer.

The official graphical PostgreSQL tool is named pgAdmin3 if I recall correctly.

anitabenites201 · January 29, 2020, 6:05pm

Thanks for the information!

acrolink · January 29, 2020, 6:34pm

I highly recommend this graphical tool:

https://www.heidisql.com

baldwindavid · January 29, 2020, 7:05pm

If you’re on a Mac, I love Postico. Super easy to use and the free version does plenty.

https://eggerapps.at/postico/

maz · January 29, 2020, 7:58pm

I use Postico (free) all the time and it’s a great app. One annoying thing about it is it doesn’t seem to pick up a db drop, create and refresh while it has the db open. Have to restart and reconnect it seems.

mindriot · January 29, 2020, 8:29pm

Have to say for Mac I love Postico too. Also really like Postgres.app from the same company as well for a no hassle local dev db server (https://postgresapp.com/).

dgreiss · January 29, 2020, 10:40pm

I really like TablePlus. Really easy to use and a clean UI.

anitabenites201 · January 29, 2020, 11:09pm

Thank you to all of you for your recommendations!