2017-03-03T21:45:00Z

What is the best GUI tool for development and management of a PostgreSQL database?


I'm interested to hear what people feel is the best tool for a developer and administrator who has a background with Oracle / MS SQL Server.

Guest
1111 Answers

author avatar
Vendor

My recommendation also pgAdmin to access the PostgreSQL.

2017-05-30T05:03:51Z
author avatar
Consultant

Hi,

I have used pgAdmin and definitely it is a complete tool to do management and development tasks as well, it could be run on a desktop or on a server to provide web access.
I'm an open source fan so, I recommend it :)

there my two cents

Jairo

2017-03-08T14:58:54Z
author avatar
Vendor

PgAdmin (https://www.pgadmin.org/) is a good tool and free.
Another one is EMS Sql Manager, it's free but you must pay for use some parts of this tool.

2017-03-08T08:07:21Z
author avatar
Consultant

pgadmin is enough for most of the activities

2017-03-08T04:47:06Z
author avatar
Vendor

I'd recommend using DataGrip. It's a commercial tool from Jetbrains, but it actually supports many databases and is java based. It will run on windows, mac and linux systems. It also supports syntax highlighting and auto completion.

They offer a free trial. If you need something free, pgAdmin III is a good option as well.

2017-03-08T00:08:09Z
author avatar
Vendor
2017-03-07T21:42:38Z
author avatar
Consultant

pgAdmin is pretty good.

2017-03-07T18:55:23Z
author avatar
Vendor

I'm personally a big fan of DbVisualizer. It works with any SQL DB.

2017-03-07T17:54:06Z
author avatar
Consultant

Hi Tejpal,

I have worked with PostgreSQL since version 8.3, and pgadmin has been more than enough for my tasks; however, once I tested Navicat (which is propietary) and I think it has a lot of features closer to clients as Toad (for example).

You can test both and decide by yourself which option is better for you..

Regards..

--
Álvaro

2017-03-07T17:16:17Z
author avatar
Consultant

Managing PostgreSQL and Developing applications on PostgreSQL are two very different activities. If you are looking for a low cost open source option for managing PostgreSQL then I would suggest Nagios.
For development of applications on PostgreSQL, you have many options and the selection would depend on type of an application. If your application needs data mining or complex data handling functions then Python (with Idle IDE) is a better option. If you are looking for a scalable web based application then Java should suffice.

Hope this helps.

Shrikant

2017-03-07T16:05:27Z
author avatar
Top 5LeaderboardConsultant

Will you be on windows or mac computer?

2017-03-07T15:51:47Z
Find out what your peers are saying about PostgreSQL and others in Database Development and Management. Updated: October 2020.
448,775 professionals have used our research since 2012.