Pgadmin III Alternative - Windows

windows postgresql er-diagrams
Anthony Greco picture Anthony Greco · Oct 12, 2011 · Viewed 22.5k times · Source

I am looking for an alternative to the free pgAdmin III that works on windows. I basically need it for managing my tables / views / SP / etc. If it did ER diagrams, that is a huge plus, and I like them to make sure all my tables are linking together.

I am used to SQL Server Management Studio and Workbench, so I am looking for for something updated to that. pgAdmin III works, but lacks key things. Example, if I update a SP (function), I have to actually refresh the app so it notices it. Else if I go to re-edit it, it loads my old SP. This caused me to mess up several times. Also ER diagrams is a huge feature it's lacking.

While I do not mind a commercial alternative, I am not looking for a $500 bill. I would really like to keep under 250 is possible.

Please note, I have already tried PostgreSQL Maestro. It works nice, but commonly locks up. I would prefer something a bit more stable and thread safe. Example, once a query is running I can't cancel. It has the option but says, its already running so I have to end the process to stop it. I am also aware of [http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools] however I am looking for feedback by people who actually used the tools. I really do not want to try our 15 different options.

Thanks all in advance!

Answer

Adrian picture Adrian · Sep 11, 2012

DataGrip/ IntelliJ IDEA Ultimate Edition

If you are already a user of Jetbrains tools, you may try DataGrip (or the database plugin, when you are an IntelliJ IDEA Ultimate edition user). This is quite new, but suitable for most use cases.

https://www.jetbrains.com/datagrip/

DBVisualizer

DBVisualizer is a very good solution for connecting to "any" DBMS with lots of features. There is a free version avaible, but the pro version is really worth the money:

http://www.dbvis.com/

HeidiSQL

A free and very good client for MySQL, PostgreSQL and SQL Server. It really evolved the last years.

http://www.heidisql.com

Squirrel SQL

Another quite good tool is Squirrel SQL. It's not the most intuitiv and beautiful tool, but has many useful features too:

http://squirrel-sql.sourceforge.net/

DBeaver

Another open source tool with a free community edition. This is something for Eclipse users, as it is build upon Eclipse and can be installed as Eclipse plugin as well.

https://dbeaver.io

MySQL Workbench

This is not for PostgreSQL, but my answer is quite generic, so I wanted to add this as well.

MySQL Workbench is the officiel tool from Oracle for connecting to MySQL. It is really good for working with MySQL.

https://www.mysql.de/products/workbench/

Others:

Related questions

How do I enable php to work with postgresql?

<?php try { $dbh = new PDO('pgsql:host=localhost;port=5432;dbname=###;user=###;password=##'); echo "PDO connection object created"; } catch(PDOException $e) { echo $e->getMessage(); } ?> I get the error message "Could Not Load Driver"

Read More
good postgresql client for windows?

coming back to postgresql after several years of oracle ... what are the state-of-the art postgresql administrative/ddl generating/data inserting frontends on windows? it would be nice if it had integration for postgis as well. it should be standalone or …

Read More
How to Allow Remote Access to PostgreSQL database

I have PostgreSQL 9.2 Installed in Windows 7 and I have windows XP installed in Virtual Machine, how do I connect these two databases and allow remote access to add/edit the database from both Systems ?

Read More