适用于 Windows 的好的 postgresql 客户端？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/105788/
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 postgresql client for windows?
提问by Andreas Petersson
coming back to postgresql after several years of oracle ...
oracle 几年后回到 postgresql ......
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
Windows 上最先进的 postgresql 管理/ddl 生成/数据插入前端是什么？如果它也能与 postgis 集成，那就太好了。它应该是独立的，或者是intellij idea的插件
thinking back, all the windows programs specific for postgresql i have used were crap, especially PGAdmin. had it become better?
回想起来，我使用过的所有特定于 postgresql 的 Windows 程序都是垃圾，尤其是 PGAdmin。它变得更好了吗？
采纳答案by Francis B.
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.
我喜欢Postgresql Maestro。我也将他们的版本用于 MySql。我对他们的产品非常满意。或者您可以使用免费工具 PgAdmin。
回答by Arthur Thomas
do you mean something like pgAdminfor administration?
你的意思是像pgAdmin 这样的管理吗？
回答by jwfearn
回答by amrtn
Actually there is a freeware version of EMS's SQL Managerwhich is quite powerful
实际上有一个免费版本的 EMS 的SQL 管理器，它非常强大
回答by Will
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).
我强烈推荐 Navicat。我发现特别出色的是它的导入功能 - 您几乎可以导入任何数据格式（Access、Excel、DBF、Lotus ...），定义可以保存且可重复的源和目标之间的映射（我什至保留我的版本控制下的映射）。
I have tried SQLMaestro and found it buggy (particularly for data import); PGAdmin is limited.
我尝试过 SQLMaestro 并发现它有问题（特别是对于数据导入）；PGAdmin 是有限的。
回答by johny
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:
对于为 Postgres 寻找支持 Web 的客户端的任何人，我将在此处提供 TeamPostgreSQL 的链接，这是一个用于 pg 的非常精美的 AJAX Web 客户端：
回答by Herge
EMS's SQL Manageris 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.
EMS 的SQL 管理器比 phpPgAdmin 或 PG Admin III 更易于使用并且具有更多功能。但是，它只是窗户，您必须为此付费。
回答by vog
phpPgAdminis PostgreSQL web frontend which is quite good.
phpPgAdmin是 PostgreSQL 网络前端，非常好。
回答by Liam
SQLExplorer is a great Eclipse plugin or standalone interface that works with many different database systems, either with dedicated drivers or with ODBC.
SQLExplorer 是一个出色的 Eclipse 插件或独立界面，可与许多不同的数据库系统一起使用，无论是专用驱动程序还是 ODBC。
