4 ms·
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.
by qd011 3y 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.
- hans_castorp 3y agoThere are many alternative clients: https://wiki.postgresql.org/wiki/PostgreSQL_Clients https://wiki.postgresql.org/wiki/PostgreSQL_Clients
- efxhoy 3y agopsql 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.
- ubercore 3y agopgcli is also a great middleground between psql and gui
- qd011 3y agopsql is good but how do you manage long multi line queries and saved collections of queries to reuse? or connections to multiple databases?
- efxhoy 3y agoI 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.