good postgresql client for windows? [closed]

U

9

85

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?

Unnerve answered 19/9, 2008 at 21:28 Comment(8)

For questions like these, I think sometimes the best place to look is alternativeto.net – Malacostracan 13/4, 2012 at 9:51

Here is a list of software available Trying out LibreOffice right now and it seems to work well with PostgreSQL – Ladoga 12/12, 2012 at 16:12

very funny of you to close a question from '08 at the end of '12 – Unnerve 30/12, 2012 at 15:11

yep pgadmin is crap, I don't know why some devs force advice to use it :( – Response 27/4, 2015 at 20:21

As an alternative to pgadmin we have been writing sqlectron.github.io its open source – Barry 2/12, 2015 at 22:6

Really enjoying using this. so much better than the horribly slow, unstable PGAdmin III – Munoz 17/3, 2016 at 14:20

dbForge Studio for PostgreSQL is released! – Comment 23/3, 2018 at 9:49

I make Beekeeper Studio -- it uniquely focuses on ease of use and a modern UI. Built by a small team (mostly me), that just loves making good software. I also have an open source community edition. – Hatfield 16/5, 2024 at 15:36

L

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.

Legere answered 19/9, 2008 at 21:47 Comment(4)

PGMaestro seems very similar to EMS's SQL Manager (which has a free version). – Malacostracan 8/8, 2011 at 12:28

This not free or open source – Dodgson 2/4, 2018 at 6: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... – Whipstitch 7/2, 2019 at 17:12

I got fed up with all these old-school Java apps, so I built Beekeeper Studio, the community edition is free & open source, and works great on all OSes. Launched in 2020, and I have hundreds of thousands of active users. – Hatfield 16/5, 2024 at 15:38

A

24

do you mean something like pgAdmin for administration?

Agrology answered 19/9, 2008 at 21:32 Comment(6)

PGAdmin is better now than it used to be. It still leaves a lot to desire, but it is usable. – Darksome 22/9, 2008 at 9:45

pgAdmin doesn't even have auto complete capabilities. For me at least this is essential. – Maund 26/1, 2015 at 10:48

pgAdmin does not sort columns in accessible way, does not utilise tabs, just breeds windows, how crude and crappy this software is! – Response 27/4, 2015 at 20:25

pgAdmin is awful. Massively unstable, and crashes regularly. Pick something else! – Pandemic 20/11, 2017 at 16:33

pgAdmin v4 is even worse: Catastrohpically slow, bad shortcut support, grotesque UI. – Katlin 4/7, 2018 at 12:42

I made this comment back in 2008. I believe it still has its uses but I never use it myself. :) – Agrology 26/8, 2018 at 5:11

L

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.

Legere answered 19/9, 2008 at 21:47 Comment(4)

PGMaestro seems very similar to EMS's SQL Manager (which has a free version). – Malacostracan 8/8, 2011 at 12:28

This not free or open source – Dodgson 2/4, 2018 at 6: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... – Whipstitch 7/2, 2019 at 17:12

I got fed up with all these old-school Java apps, so I built Beekeeper Studio, the community edition is free & open source, and works great on all OSes. Launched in 2020, and I have hundreds of thousands of active users. – Hatfield 16/5, 2024 at 15:38

H

10

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

Hallee answered 5/10, 2010 at 19:17 Comment(5)

There's also a free version of DbVisualizer. – Malacostracan 22/7, 2011 at 13:37

@newenglander: yes, the free version is very good. That's what I use. – Hallee 27/7, 2011 at 21:18

free version is somewhat crap. ok if all you need is only basic functionality – Pastime 14/3, 2012 at 0: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. – Hallee 27/3, 2012 at 21:6

I agree, the free version of dbVis works very well. Thanks for the hint. – Syncytium 18/4, 2019 at 13:37

M

9

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

Marvin answered 31/10, 2008 at 8:48 Comment(2)

That freeware version keeps telling me that I pirated it and shutting down. "Great" software. – German 13/11, 2013 at 15:55

Free version limits you to 5 database connections. Not database server connections, 5 database connections. – Mugger 5/2, 2019 at 22:15

W

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.

Waikiki answered 12/5, 2010 at 13:35 Comment(1)

from what I have tried, no matter paid or free, Navicat is the best, at least they have the most intuitive UI – Whipstitch 4/3, 2019 at 19:39

P

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

Phiona answered 13/1, 2011 at 9:36 Comment(0)

S

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.

Semipro answered 19/9, 2008 at 23:8 Comment(0)

L

1

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

Recommended topics

Hot tags