Re:PgAdmin 4 v8.0
by qd011 on Wednesday November 29, 2023 @07:36AM
(#38458620)
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.
[ Parent
| on HN ]
Re:PgAdmin 4 v8.0
by hans_castorp on Wednesday November 29, 2023 @08:17AM
(#38458961)
There are many alternative clients:
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.
psql is good but how do you manage long multi line queries and saved collections of queries to reuse? or connections to multiple databases?
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.