database 对于 Postgres (Windows)，是否有与 TOAD 一样好的东西？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/752820/
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
Is there anything as good as TOAD for Postgres (Windows)?
提问by
I'm just looking for a management tool like TOAD for Postgres. Anyone used a good one?
我只是在为 Postgres 寻找像 TOAD 这样的管理工具。有人用过好用的吗？
Edit - I work mostly within the data itself and the database already has a mature model/design. I use the edit windows the most (well, in TOAD for Oracle anyway.)
编辑 - 我主要在数据本身内工作，并且数据库已经有了成熟的模型/设计。我最常使用编辑窗口（好吧，无论如何，在 TOAD for Oracle 中。）
As far as I know, Toad only exists naturally for: Oracle, MS SQL, DB2 and MySQL...
据我所知，Toad 只自然存在于：Oracle、MS SQL、DB2 和 MySQL...
--JS
--JS
采纳答案by Will Green
Not sure if TOAD for specific DB versions is any different than TOAD for Data Modeler, but it appears that TOAD Data Modelersupports PostgreSQL, along with a few others.
不确定用于特定数据库版本的 TOAD 是否与用于数据建模器的 TOAD 有任何不同，但似乎TOAD 数据建模器支持 PostgreSQL 以及其他一些。
If you're looking for something like SQL Server Management Studio, but for Postgres, how about EMS SQL Manageror Lightning Admin?
如果您正在寻找 SQL Server Management Studio 之类的东西，但对于 Postgres，EMS SQL Manager或Lightning Admin怎么样？
回答by jishi
Doesn't TOAD exist for several plattforms?
TOAD 不存在多个平台吗？
I'm using pgAdmin III which fills my needs so far.
到目前为止，我正在使用 pgAdmin III 来满足我的需求。
回答by Frank Heikens
回答by User1
TOrahas some nice features and is supposed to be a lot like TOAD. Also, it is completely GPL so you can change the code yourself.
TORA有一些不错的功能，应该很像 TOAD。此外，它完全是 GPL，因此您可以自己更改代码。
BTW: Toad is not OpenSource and is now only trialware (must re-install every 120 days). TOra is OpenSource so you don't have those issues.
顺便说一句：Toad 不是开源的，现在只是试用软件（必须每 120 天重新安装一次）。TOra 是开源的，因此您不会遇到这些问题。
回答by Nic Gibson
I've used Navicatfairly extensively and successfully but only on a Mac. It has a Windows implementation that is, as far as I know, more feature rich than the Mac implementation.
我已经相当广泛和成功地使用Navicat，但只在 Mac 上使用。它有一个 Windows 实现，据我所知，它比 Mac 实现的功能更丰富。
I've had the odd data typing issue with it but, if you are not doing data modelling, that may not be an issue for you
我遇到了奇怪的数据类型问题，但是，如果您不进行数据建模，那对您来说可能不是问题
回答by Daniel Honig
Navicat for PostgreSQL is working really well for me natively. I set up phppgAdmin for the teams general use and it has been quite valuea ble
Navicat for PostgreSQL 对我来说非常好用。我为团队一般使用设置了 phppgAdmin，它非常有价值
回答by Dwi Santoso
Because you do not need to edit the database design, I suggest SQL Workbench/J. It is Java application. You can use GUI mode (which I prefer to) and console mode (if you like psql-like command console). I use this app much more than pgAdmin III or pgAdmin 4 because it helps me to ease monitoring the database activity, deploying new version of DB app, etc.
因为不需要编辑数据库设计，我建议使用SQL Workbench/J。它是Java应用程序。您可以使用 GUI 模式（我更喜欢）和控制台模式（如果您喜欢类似 psql 的命令控制台）。我使用这个应用程序比 pgAdmin III 或 pgAdmin 4 多得多，因为它可以帮助我轻松监控数据库活动、部署新版本的数据库应用程序等。
