good postgresql client for windows?

Postgresql

Postgresql Problem Overview

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?

Postgresql Solutions

Solution 1 - Postgresql

do you mean something like pgAdmin for administration?

Solution 2 - Postgresql

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.

Solution 3 - Postgresql

I heartily recommended dbVis. The client runs on Mac, Windows and Linux and supports a variety of database servers, including PostgreSQL.

Solution 4 - Postgresql

Actually there is a freeware version of EMS's SQL Manager which is quite powerful

Solution 5 - Postgresql

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.

Solution 6 - Postgresql

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:

http://www.teampostgresql.com

Solution 7 - Postgresql

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.

Solution 8 - Postgresql

SQLExplorer is a great Eclipse plugin or standalone interface that works with many different database systems, either with dedicated drivers or with ODBC.

Solution 9 - Postgresql

http://phppgadmin.sourceforge.net/">phpPgAdmin</a> is PostgreSQL web frontend which is quite good.

Categories
Recommended Postgresql Solutions

Previous Solution:

Differences between MSIL and Java bytecode?

Java.NetBytecodeCil

Next Solution:

How do I convert a System.Type to its nullable version?

C#.Net

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionAndreas PeterssonView Question on Stackoverflow
Solution 1 - PostgresqlArthur ThomasView Answer on Stackoverflow
Solution 2 - PostgresqlFrancis B.View Answer on Stackoverflow
Solution 3 - PostgresqljwfearnView Answer on Stackoverflow
Solution 4 - PostgresqlamrtnView Answer on Stackoverflow
Solution 5 - PostgresqlWillView Answer on Stackoverflow
Solution 6 - PostgresqljohnyView Answer on Stackoverflow
Solution 7 - PostgresqlHergeView Answer on Stackoverflow
Solution 8 - PostgresqlLiamView Answer on Stackoverflow
Solution 9 - PostgresqlvogView Answer on Stackoverflow