# PostgreSQL management tool other than PgAdmin **URL:** \ **Category:** General Discussion\ **Created:** [September 20, 2023, 6:08am UTC](https://forum.inductiveautomation.com/t/postgresql-management-tool-other-than-pgadmin/79375 "2023-09-20T06:08:11Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [September 20, 2023, 6:08am UTC](https://forum.inductiveautomation.com/t/postgresql-management-tool-other-than-pgadmin/79375/1 "2023-09-20T06:08:11Z")
Is there a decent free management tool for Postgre that you would recommend? Going from SSMS to PgAdmin is rather depressing... ☹ ---
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [September 20, 2023, 6:13am UTC](https://forum.inductiveautomation.com/t/postgresql-management-tool-other-than-pgadmin/79375/2 "2023-09-20T06:13:16Z")
we use pgAdmin, simple and free, but limited, so perhaps other to consider IMHO: - Jetbrain DataGrip - Dbeaver with a community edition ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [September 20, 2023, 6:27am UTC](https://forum.inductiveautomation.com/t/postgresql-management-tool-other-than-pgadmin/79375/3 "2023-09-20T06:27:32Z")
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... 😩 ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [September 20, 2023, 12:08pm UTC](https://forum.inductiveautomation.com/t/postgresql-management-tool-other-than-pgadmin/79375/4 "2023-09-20T12:08:35Z")
> [@nminchin](#): > > will fork out for a licence Datagrip pushed me over the edge to buy their whole toolkit. I already wanted IntelliJ and PyCharm, and Datagrip sealed the deal. Highly recommended. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [September 20, 2023, 12:14pm UTC](https://forum.inductiveautomation.com/t/postgresql-management-tool-other-than-pgadmin/79375/5 "2023-09-20T12:14:07Z")
> [@pturmel](#): > > Highly recommended. Second... I own a personal JetBrains "all products" license separate from the one provided to me by IA. ---
**Author:** ![humphrey.daniel](https://avatars.discourse-cdn.com/v4/letter/h/8e8cbc/32.png) [@humphrey.daniel](https://forum.inductiveautomation.com/u/humphrey.daniel)\ **Post date:** [September 20, 2023, 3:08pm UTC](https://forum.inductiveautomation.com/t/postgresql-management-tool-other-than-pgadmin/79375/6 "2023-09-20T15:08:13Z")
I use Azure Data Studio for it's similarity to VS Code. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [September 20, 2023, 8:04pm UTC](https://forum.inductiveautomation.com/t/postgresql-management-tool-other-than-pgadmin/79375/7 "2023-09-20T20:04:40Z")
Maybe some of my issues with Postgre are not IDE-related, like this one for example happens in DataGrip as well: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/6/76eea3194eefdbd3a367bfe4a5d96174dc334334.png) It's a View, it's not a table - why can't I drop columns from it?? I'm still in dev ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [September 20, 2023, 9:17pm UTC](https://forum.inductiveautomation.com/t/postgresql-management-tool-other-than-pgadmin/79375/8 "2023-09-20T21:17:40Z")
You generally just rerun the CREATE operation for a view. There's no data involved. ---
**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Post date:** [September 21, 2023, 5:08am UTC](https://forum.inductiveautomation.com/t/postgresql-management-tool-other-than-pgadmin/79375/9 "2023-09-21T05:08:10Z")
For 12 years now, I have used [SQL Manager for Postgres](https://www.sqlmanager.net/products/postgresql/manager). 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...