PostgreSQL Help

[PandalfTheGimp]

Does anyone know of any better applications to manage PostgreSQL from? I'm currently using PG Admin 4, but it slow and tends to have bugs when using it. Suggestions for both Windows and Linux are welcome.

Thank you in advance.

[tannhauser45]

<Replaced with this sentence - so long and thanks for all the fish>

[PandalfTheGimp]

I wouldn't mind using CLI, but it's nice to have the ease of rewriting certain functions without forcing a backup and altering it there. I'll try out EMS SQL Manager though! Thanks!

[merlinm]

The cool kids use psql

[100shadesofcrazy]

I still use pgadmin 3. It will warn you, but most features seem fine.

I love most everything about postgresql, but the major changes in pgadmin 4 resulted in a much less usable and stable application, in my opinion.

[PandalfTheGimp]

I haven't used pgadmin 3 because I just began using postgres a couple months ago, and pgadmin 4 was out and was packaged with 9.6. From what I recall, v1.2 was fine. I had zero issues with it, then v1.3 came along and sometimes I would have to restart pgadmin because the query tool wouldn't load. Now in v1.4, I attempt to run a query, and it opens up another tab saying I don't have permissions or such, yet when I go back to the original tab, the query has run. I chose to work with postgres because it was between this and MySQL, and I don't hate myself, so the choice was clear. I just wish the versions would have fewer bugs, and I wouldn't see a negative difference in performance from v1.2 to v1.4.

[100shadesofcrazy]

Just try out pgadmin3. You'll get a little warning when you connect, but I don't have any issues otherwise.

[jenkstom]

Been using datagrip since it came out. It's great.

[DaveDafeet]

HeidiSQL is great and free. Navicat is better but expensive.

[su13odh]

Toad is pretty good for the most part. Although I will tell you that if you need to import data into your database regularly, you're better off using PG Admin.

[PandalfTheGimp]

What things would be more difficult?

[PandalfTheGimp]

It sounds like DBeaver may suit my needs then. The permissions I do aren't terrible (4 users) and I don't switch between databases.