Text-based interface for PostgreSQL?

Question

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?

• András Váczi: What do you mean by 'SQL is an option'?
• TinyProton: 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.
• András Váczi: I am afraid I've never heard about such a tool...
• MatheusOl: 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)...
• user1822: There is a phpPgAdmin and there are tons of other GUI tools: wiki.postgresql.org/wiki/… but I doubt you'll find anything that works on the console (i.e. non-graphical)

Answer 1

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

• xenoterracide: 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.
• TinyProton: 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.
• Chris Travers: you can do this with psql, actually @TinyProton. See the \d commands. Use \? for a list.

Answer 2

Nearly nine years late (hahaha) but I've just seen this:

Rust TUI for PostgreSQL

• Ruslan: I loved this one and had such high hopes for it, but it looks like the project isn't very active... There's this other one though that I've been following! github.com/jorgerojas26/lazysql