Active6 years, 8 months ago
PgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. PgAdmin may be used on Linux, Unix, Mac OS X and Windows to manage PostgreSQL 9.2 and above.
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 alternatively a plugin for intellij idea
thinking back, all the windows programs specific for postgresql i have used were crap, especially PGAdmin. had it become better?
Andreas Petersson
Andreas PeterssonAndreas Petersson13.5k1111 gold badges5353 silver badges8888 bronze badges
closed as not constructive by Bo Persson, Linger, Jens Björnhager, AlphaMale, CésarDec 13 '12 at 14:40
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
9 Answers
I like Postgresql Maestro. I also use their version for MySql. I'm pretty statisfied with their product. Or you can use the free tool PgAdmin.
Francis B.Francis B.![Client Client](/uploads/1/2/6/1/126168854/922118783.png)
6,24322 gold badges2828 silver badges5353 bronze badges
do you mean something like pgAdmin for administration?
Milen A. Radev46.5k1818 gold badges9595 silver badges101101 bronze badges
Arthur ThomasArthur Thomas4,57411 gold badge2020 silver badges3030 bronze badges
Actually there is a freeware version of EMS's SQL Manager which is quite powerful
amrtnamrtn
I heartily recommended dbVis. The client runs on Mac, Windows and Linux and supports a variety of database servers, including PostgreSQL. Best ftp client for mac reddit.
jwfearnjwfearn18.9k2222 gold badges8282 silver badges112112 bronze badges
I recommend Navicat strongly. What I found particularly excellent are it's import functions - you can import almost any data format (Access, Excel, DBF, Lotus ..), define a mapping between the source and destination which can be saved and is repeatable (I even keep my mappings under version control).
I have tried SQLMaestro and found it buggy (particularly for data import); PGAdmin is limited.
WillWill
For anyone looking for a web-enabled client for Postgres, I'll just put the link out here to TeamPostgreSQL, a very polished AJAX web client for pg:
johnyjohny
EMS's SQL Manager is much easier to use and has many more features than either phpPgAdmin or PG Admin III. However, it's windows only and you have to pay for it.
Postgresql Client Download
HergeHerge6,97944 gold badges1919 silver badges1717 bronze badges
SQLExplorer is a great Eclipse plugin or standalone interface that works with many different database systems, either with dedicated drivers or with ODBC.
LiamLiam10.6k2020 gold badges7474 silver badges102102 bronze badges
phpPgAdmin is PostgreSQL web frontend which is quite good.
vogvogPostgresql Gui Client
12.1k66 gold badges4040 silver badges6060 bronze badges