News for hackers. Stuff that matters.
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.
Re:PgAdmin 4 v8.0 by hans_castorp on Wednesday November 29, 2023 @08:17AM (#38458961)
There are many alternative clients:

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

Re:PgAdmin 4 v8.0 by efxhoy on Wednesday November 29, 2023 @08:21AM (#38459002)
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.

Re:PgAdmin 4 v8.0 by qd011 on Wednesday November 29, 2023 @11:05AM (#38461145)
psql is good but how do you manage long multi line queries and saved collections of queries to reuse? or connections to multiple databases?
Re:PgAdmin 4 v8.0 by efxhoy on Wednesday November 29, 2023 @03:40PM (#38464995)
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.
Re:PgAdmin 4 v8.0 by ubercore on Wednesday November 29, 2023 @08:29AM (#38459076)
pgcli is also a great middleground between psql and gui