good postgresql client for windows?

Question

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?

For questions like these, I think sometimes the best place to look is http://alternativeto.net — newenglander, Apr 13 '12 at 09:51
Here is a [list of software available](http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools#Open_Source_.2F_Free_Software) Trying out LibreOffice right now and it seems to work well with PostgreSQL — Oleg, Dec 12 '12 at 16:12
very funny of you to close a question from '08 at the end of '12 — Andreas Petersson, Dec 30 '12 at 15:11
yep pgadmin is crap, I don't know why some devs force advice to use it :( — Marecky, Apr 27 '15 at 20:21
As an alternative to pgadmin we have been writing http://sqlectron.github.io/ its open source — krolow, Dec 02 '15 at 22:06
Really enjoying using this. *so* much better than the horribly slow, unstable PGAdmin III — Simon Woolf, Mar 17 '16 at 14:20
[dbForge Studio for PostgreSQL](https://www.devart.com/dbforge/postgresql/studio/) is released! — Devart, Mar 23 '18 at 09:49

score 24 · Answer 1 · edited Dec 13 '12 at 07:32

24

do you mean something like pgAdmin for administration?

edited Dec 13 '12 at 07:32

Milen A. Radev

60,241
22
105
110

answered Sep 19 '08 at 21:32

Arthur Thomas

5,088
1
25
31

6

PGAdmin is better now than it used to be. It still leaves a lot to desire, but it is usable. – Mauli Sep 22 '08 at 09:45
1

pgAdmin doesn't even have auto complete capabilities. For me at least this is essential. – Mateus Viccari Jan 26 '15 at 10:48
5

pgAdmin does not sort columns in accessible way, does not utilise tabs, just breeds windows, how crude and crappy this software is! – Marecky Apr 27 '15 at 20:25
2

pgAdmin is awful. Massively unstable, and crashes regularly. Pick something else! – RedSands Nov 20 '17 at 16:33
2

pgAdmin v4 is even worse: Catastrohpically slow, bad shortcut support, grotesque UI. – Jinxed Jul 04 '18 at 12:42
I made this comment back in 2008. I believe it still has its uses but I never use it myself. :) – Arthur Thomas Aug 26 '18 at 05:11

score 16 · Accepted Answer · answered Sep 19 '08 at 21:47

16

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.

answered Sep 19 '08 at 21:47

Francis B.

7,018
2
32
54

1

PGMaestro seems very similar to EMS's SQL Manager (which has a free version). – newenglander Aug 08 '11 at 12:28
3

This not free or open source – user881703 Apr 02 '18 at 06:14
just tried to use PGMaestro for 3 days, it's a complete disaster, it is unusable garbage, with terrible UX, how they even sell that product... – Khachatur Stepanyan Feb 07 '19 at 17:12

jwfearn · Answer 3 · 2011-01-21T21:29:02.390

10

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

edited Jan 21 '11 at 21:29

answered Oct 05 '10 at 19:17

jwfearn

28,781
28
95
122

There's also a free version of DbVisualizer. – newenglander Jul 22 '11 at 13:37
@newenglander: yes, the free version is very good. That's what I use. – jwfearn Jul 27 '11 at 21:18
2

free version is somewhat crap. ok if all you need is only basic functionality – Imre L Mar 14 '12 at 00:34
The free version used to be better (you could have open multiple SQL files) but recent versions are now limited to one file open at a time. But it's still solid and for a FREE tool, it's very high quality. Of course there are more features in the pay version. – jwfearn Mar 27 '12 at 21:06
I agree, the free version of dbVis works very well. Thanks for the hint. – Chris Tophski Apr 18 '19 at 13:37

score 9 · Answer 4 · answered Oct 31 '08 at 08:48

9

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

answered Oct 31 '08 at 08:48

amrtn

587
4
10

2

That freeware version keeps telling me that I pirated it and shutting down. "Great" software. – Alex Weinstein Nov 13 '13 at 15:55
Free version limits you to 5 database connections. Not database server connections, 5 *database* connections. – jpmc26 Feb 05 '19 at 22:15

score 6 · Answer 5 · answered May 12 '10 at 13:35

6

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.

answered May 12 '10 at 13:35

Will

877
11
25

from what I have tried, no matter paid or free, Navicat is the best, at least they have the most intuitive UI – Khachatur Stepanyan Mar 04 '19 at 19:39

score 4 · Answer 6 · answered Jan 13 '11 at 09:36

4

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

answered Jan 13 '11 at 09:36

johny

41
1

score 3 · Answer 7 · answered Sep 19 '08 at 23:08

3

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.

answered Sep 19 '08 at 23:08

Herge

20,857
4
23
17

score 1 · Answer 8 · answered Sep 19 '08 at 21:31

1

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

answered Sep 19 '08 at 21:31

Liam

19,819
24
83
123

score 1 · Answer 9 · answered Sep 19 '08 at 22:55

1

phpPgAdmin is PostgreSQL web frontend which is quite good.

answered Sep 19 '08 at 22:55

vog

23,517
11
59
75

good postgresql client for windows?

9 Answers9

Linked