Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I know that psql is an option, but I'm looking for an easier text-based interface for PostgreSQL. Something that's similar to what 'tig' is to 'git', or 'phpmyadmin' is to 'mysql' (but using the command line). does any one know something like this?

share|improve this question

migrated from Sep 11 '13 at 16:37

This question came from our site for system and network administrators.

What do you mean by 'SQL is an option'? – dezso Sep 11 '13 at 19:43
I mean that I can use psql to write queries and see the results, but that's not what I want. I'm looking for an application that allows me to explore the DBs from the terminal without writing SQL statements. – TinyProton Sep 12 '13 at 1:36
I am afraid I've never heard about such a tool... – dezso Sep 12 '13 at 4:54
What exactly are you trying to do that psql cannot accomplish? I also never heard a similar tool, at least not one better than psql (which is the most advanced/powerful prompt tool of all SGDBs I've ever used)... – MatheusOl Sep 12 '13 at 5:26
There is a phpPgAdmin and there are tons of other GUI tools:… but I doubt you'll find anything that works on the console (i.e. non-graphical) – a_horse_with_no_name Sep 12 '13 at 6:24

I believe what you're looking for is psql, which is Postgres' command line tool.

share|improve this answer
I don't think he is, he's looking for something that's more of a curses interface. think, he wants top instead of ps. – xenoterracide Sep 11 '13 at 20:43
No that's not what I'm looking for, sorry for not being clear. I want something that would allow me to explore the DBs without writing SQL statements. – TinyProton Sep 12 '13 at 1:33
you can do this with psql, actually @TinyProton. See the \d commands. Use \? for a list. – Chris Travers Sep 12 '13 at 12:18

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.