good postgresql client for windows? [closed]

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?

do you mean something like pgAdmin for administration?

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.

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

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