Pgadmin III 替代方案 - Windows
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7736270/
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
Pgadmin III Alternative - Windows
提问by Anthony Greco
I am looking for an alternative to the free pgAdmin III that works on windows. I basically need it for managing my tables / views / SP / etc. If it did ER diagrams, that is a huge plus, and I like them to make sure all my tables are linking together.
我正在寻找适用于 Windows 的免费 pgAdmin III 的替代方案。我基本上需要它来管理我的表 / 视图 / SP / 等。如果它做了 ER 图表，那是一个巨大的优势，我喜欢它们确保我的所有表都链接在一起。
I am used to SQL Server Management Studio and Workbench, so I am looking for for something updated to that. pgAdmin III works, but lacks key things. Example, if I update a SP (function), I have to actually refresh the app so it notices it. Else if I go to re-edit it, it loads my old SP. This caused me to mess up several times. Also ER diagrams is a huge feature it's lacking.
我习惯了 SQL Server Management Studio 和 Workbench，所以我正在寻找更新的东西。pgAdmin III 有效，但缺少关键的东西。例如，如果我更新一个 SP（函数），我必须实际刷新应用程序以便它注意到它。否则，如果我去重新编辑它，它会加载我的旧 SP。这让我搞砸了好几次。ER 图也是它所缺乏的一个重要功能。
While I do not mind a commercial alternative, I am not looking for a $500 bill. I would really like to keep under 250 is possible.
虽然我不介意商业替代品，但我不是在寻找 500 美元的钞票。我真的想保持在250以下是可能的。
Please note, I have already tried PostgreSQL Maestro. It works nice, but commonly locks up. I would prefer something a bit more stable and thread safe. Example, once a query is running I can't cancel. It has the option but says, its already running so I have to end the process to stop it. I am also aware of [http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools] however I am looking for feedback by people who actually used the tools. I really do not want to try our 15 different options.
请注意，我已经尝试过 PostgreSQL Maestro。它工作得很好，但通常会锁定。我更喜欢更稳定和线程安全的东西。例如，一旦查询正在运行，我就无法取消。它有选项，但说，它已经在运行，所以我必须结束这个过程来停止它。我也知道 [http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools] 但是我正在寻找实际使用这些工具的人的反馈。我真的不想尝试我们的 15 种不同的选择。
Thanks all in advance!
提前谢谢大家！
回答by Adrian
DataGrip/ IntelliJ IDEA Ultimate Edition
DataGrip/ IntelliJ IDEA 终极版
If you are already a user of Jetbrains tools, you may try DataGrip (or the database plugin, when you are an IntelliJ IDEA Ultimate edition user). This is quite new, but suitable for most use cases.
如果您已经是 Jetbrains 工具的用户，您可以尝试 DataGrip（或数据库插件，当您是 IntelliJ IDEA Ultimate 版用户时）。这是相当新的，但适用于大多数用例。
https://www.jetbrains.com/datagrip/
https://www.jetbrains.com/datagrip/
DBVisualizer
数据库可视化器
DBVisualizer is a very good solution for connecting to "any" DBMS with lots of features. There is a free version avaible, but the pro version is really worth the money:
DBVisualizer 是一个非常好的解决方案，可以连接到具有许多功能的“任何”DBMS。有一个免费版本可用，但专业版确实物有所值：
HeidiSQL
海蒂SQL
A free and very good client for MySQL, PostgreSQL and SQL Server. It really evolved the last years.
一个免费且非常好的 MySQL、PostgreSQL 和 SQL Server 客户端。它真的在过去几年发展了。
Squirrel SQL
松鼠SQL
Another quite good tool is Squirrel SQL. It's not the most intuitiv and beautiful tool, but has many useful features too:
另一个相当不错的工具是 Squirrel SQL。它不是最直观、最漂亮的工具，但也有许多有用的功能：
http://squirrel-sql.sourceforge.net/
http://squirrel-sql.sourceforge.net/
MySQL Workbench
MySQL 工作台
This is not for PostgreSQL, but my answer is quite generic, so I wanted to add this as well.
这不适用于 PostgreSQL，但我的回答很笼统，所以我也想添加这个。
MySQL Workbench is the officiel tool from Oracle for connecting to MySQL. It is really good for working with MySQL.
MySQL Workbench 是 Oracle 提供的用于连接 MySQL 的官方工具。它非常适合使用 MySQL。
https://www.mysql.de/products/workbench/
https://www.mysql.de/products/workbench/
Others:
其他：
- Oracle SQL Developerfor Oracle
- SQL Server Management Studiofor SQL Server
- 适用于 Oracle 的Oracle SQL Developer
- 适用于 SQL Server 的SQL Server Management Studio
回答by Sergey Pak
this is a very good alternative to PgAdmin, cross platform:
这是 PgAdmin 的一个很好的替代方案，跨平台：
http://navicat.com/en/products/navicat_pgsql/pgsql_overview.html
http://navicat.com/en/products/navicat_pgsql/pgsql_overview.html
Hope this helps (approx. $100-$200).
希望这会有所帮助（大约 100-200 美元）。
回答by Kuberchaun
I also come from a SQL Server Management Studio background so I know how you must feel. Give this one a trial run. I have liked it when I use it.
我也有 SQL Server Management Studio 背景，所以我知道您的感受。试运行一下。我用的时候很喜欢。
http://www.sqlmanager.net/en/products/postgresql/manager
http://www.sqlmanager.net/en/products/postgresql/manager
Also check out the studio version which bundles a bunch of apps into a suite.
还可以查看将一堆应用程序捆绑到一个套件中的工作室版本。
回答by Ali Dehghani
Recently JetBrains released a so-called Database IDEcalled DataGrip. DataGrip support most major RDBMSs like PostgreSQL, Oracle, SQL Server and MySQL. And it's commercial:
最近 JetBrains 发布了一个名为DataGrip 的数据库 IDE。DataGrip 支持大多数主要的 RDBMS，如 PostgreSQL、Oracle、SQL Server 和 MySQL。它是商业的：
DataGrip User Interface
DataGrip 用户界面
