Hacker News new | ask | show | jobs
by qd011 938 days ago
It's not a good UI, at least not on Mac. It's kind of clunky, confusing and slow. I don't know if there are many better free alternatives though.
2 comments
efxhoy 938 days ago
psql and the meta commands like \d to view schema of a table, combined with your regular text editor and \i is IMO the greatest postgres UI.

I spend a lot of time there though so I can see the appeal of a gui for someone who only occasionally looks around in the db.

link
ubercore 938 days ago
pgcli is also a great middleground between psql and gui
link
qd011 938 days ago
psql is good but how do you manage long multi line queries and saved collections of queries to reuse? or connections to multiple databases?
link
efxhoy 938 days ago
I keep queries in .sql files in git repo. I run longer queries by writing them in a file and including/running it with \i. There's also \e to open $PSQL_EDITOR.
link
hans_castorp 938 days ago
There are many alternative clients:

https://wiki.postgresql.org/wiki/PostgreSQL_Clients

link