Good Postgres graphical client for Windows [closed]

Question

The name pretty much says it all. Right now I'm using Squirrel - it crashes frequently and suffers from memory problems (I've tried increasing the heap size). I don't need anything particularly fancy or full-featured - just something that won't take up 2.4 GB of RAM to store a 1.5 million line, 8 column result set.

Fetch

Same question as #106288 – Stoneblind

dbForge Studio for PostgreSQL is available at devart.com/dbforge/postgresql/studio – Lizalizabeth

Answer 1

Use PgAdmin.

However - I don't think you'll find much that won't use a large amount of memory when you have a result set with 1.5 million rows...

PgAdmin has the ability to limit automatically the number of rows returned - so you can get an overview, but not sit for an hour waiting for your results to turn up. If you write a query to return that many rows though, than you are going to have problems.

(You can also look at the limit SQL command, to restrict how many results you get back)

Alienism

Thanks for the suggestion - I'll check it out. Out of curiosity, why would a result set that size cause memory problems for the client? – Fetch

Not going to necessarily cause memory problems, but if you are returning huge result sets, there is necessarily more memory required. Both in what is required for the data itself, plus any overhead for the row information + (it sounds like) memory leaks if you run this more than once... – Alienism

Oh, and returning over a million rows is definitely going to take some time to run. You usually won't need to see all million+ every time you test a query :) – Alienism

Note that if you have an ORDER BY in your query, the DB may be forced to compute the entire result set before sending results even if you use LIMIT. – Supinator

Answer 2

Try official pgAdmin. http://www.pgadmin.org/download/windows.php

Tautog

Answer 3

One option would be to use phpPgAdmin on the server. It’s a web app, but it’s lightweight and easy to install.

It can paginate results, so it can handle large result sets. It can’t do everything that pgAdmin can do, but for everyday use I prefer it.

Aurochs

Answer 4

NOTE: This is the same answer I gave this duplicate question.

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

Stoneblind

Answer 5

I make Beekeeper Studio, I also ship a Community Edition which is free and open source (and very full featured). Both work great with PostgreSQL.

I focus really hard on making the app intuitive and easy to use. It has a nice UI with a good looking dark mode and doesn't have a million buttons.

If you need a bunch of power features, you're probably better off with DBeaver or DataGrip, but if you prefer VSCode to IntelliJ or Eclipse, you'll probably like Beekeeper.

It's built by a small team - just me and some other part time folks. We just like making good software.

Pagandom

Answer 6

HeidiSQL has experimental support for postgres. I find HeidiSQL much easier to use than pgAdmin.

Ddene

Answer 7

Try dbeaver It has support for multiple databases including postgres and also available on Windows app store.

Limited