postgresql 适用于 Windows 的优秀 Postgres 图形客户端
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2807232/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Good Postgres graphical client for Windows
提问by alex
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.
这个名字几乎说明了一切。现在我正在使用 Squirrel - 它经常崩溃并遇到内存问题（我尝试增加堆大小）。我不需要任何特别花哨或功能齐全的东西——只是不需要占用 2.4 GB RAM 来存储 150 万行、8 列结果集的东西。
采纳答案by RodeoClown
Use PgAdmin.
使用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...
但是 - 当您的结果集包含 150 万行时，我认为您不会发现很多不会使用大量内存的内容......
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.
PgAdmin 能够自动限制返回的行数 - 这样您就可以获得概览，而不是坐一个小时等待结果出现。如果你编写一个查询来返回那么多行，那么你就会遇到问题。
(You can also look at the limitSQL command, to restrict how many results you get back)
（你也可以看看limitSQL命令，限制你返回多少结果）
回答by jozefsevcik
Try official pgAdmin. http://www.pgadmin.org/download/windows.php
尝试官方 pgAdmin。 http://www.pgadmin.org/download/windows.php
回答by Nate
One option would be to use phpPgAdminon the server. It's a web app, but it's lightweight and easy to install.
一种选择是在服务器上使用phpPgAdmin。这是一个网络应用程序，但它很轻巧且易于安装。
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.
它可以对结果进行分页，因此可以处理大型结果集。它不能做 pgAdmin 能做的所有事情，但对于日常使用，我更喜欢它。
回答by jwfearn
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.
我推荐dbVis。该客户端可在 Mac、Windows 和 Linux 上运行，并支持多种数据库服务器，包括 PostgreSQL。
