Is there a decent free management tool for Postgre that you would recommend? Going from SSMS to PgAdmin is rather depressing... 
we use pgAdmin, simple and free, but limited, so perhaps other to consider IMHO:
- Jetbrain DataGrip
- Dbeaver with a community edition
JetBeans' app looks cool (as all of their applications do), but I don't know if my company (or I) will fork out for a licence... I'm running in trial mode right now.
I saw DBeaver, it looks a bit old school, but i'll give it a go after my trial expires.
I don't like how PgAdmin has such a lack of creature comforts that let you get things done efficiently, for example, when you edit a table's data manually, you can't select multiple rows and delete them, it's 1-by-1. Verrry slow. You can't paste in data from Excel into a table, you have to either generate the INSERT statements, do a bulk insert, or manually double click (why double click? and why does it open a little edit value popup??) on each field when editing the table, manually punch in the value, click OK, and repeat 600 times... 
Datagrip pushed me over the edge to buy their whole toolkit. I already wanted IntelliJ and PyCharm, and Datagrip sealed the deal. Highly recommended.
3 Likes
Second... I own a personal JetBrains "all products" license separate from the one provided to me by IA.
4 Likes
I use Azure Data Studio for it's similarity to VS Code.
Maybe some of my issues with Postgre are not IDE-related, like this one for example happens in DataGrip as well:
It's a View, it's not a table - why can't I drop columns from it?? I'm still in dev
You generally just rerun the CREATE operation for a view. There's no data involved.
2 Likes
For 12 years now, I have used SQL Manager for Postgres.
They also have a free version, which allows connections to only 5 databases...
And I also have DBeaver Installed for occasional use, but old habits die hard, I guess...