Agreed. SQL Server Management Studio is fantastic and is one of the main reasons I enjoy working with MSSQL.
Unfortunately Postgres severely lacks in the tooling department. PgAdmin 3 used to be good, but PgAdmin 4 is simply horrendous. It makes me dread interacting with Postgres.
psql is great for inspecting schema and running ad-hoc queuries. SQL scripts can also be piped through it for cron-sql jobs etc.
pg_dump + psql + ssh to easily copy databases between hosts
pg_bench for benchmarking.
Lots more: https://www.postgresql.org/docs/current/static/reference-cli...
Postage, a tool developed by a family of software devs, was gaining popularity but recently became unmaintained without explanation (afaik). [0]
I started using IntelliJ DataGrip on a trial basis and it's good, but I probably won't pay for it. Sick of paying monthly subscription fee for every little tool I need from JetBrains, especially when I put down a project and don't need that tool for another x months.
Used DBeaver briefly but it's so many clicks just to set up a primary key that I shelved it for now. Will probably come back to it when DataGrip trial is over.
Not a conventional management tool but pgModeler [1] is a cool project IMO. Open-source, but they put a limit on the Windows binaries they distribute to try to get people to fund development. Can build from source yourself, install on Linux, or probably find free third-party builds elsewhere.
I think that most devs are just sticking with pgadmin3.
That said it seems there is little to gain except nice words for smaller open source efforts.
JetBrains' DataGrip is significantly better, and works with all the extant SQL implementations.
We can definitely debate the SQL implementations themselves, but DataGrip makes tooling a non-issue.
Does DataGrip let you do Kerberos authentication?
It allows you to manually specify every authentication parameter if you wish to, but the simple login page only supports password or client-cert auth.