linux有好的PostgreSQL客户端吗?

I am frustrated of not having a good Linux GUI administration and development tool for PostgreSQL.

我对没有一个好的用于PostgreSQL的Linux GUI管理和开发工具感到沮丧。

pgAdmin III is buggy and unusable piece of... hmm, software, compared to Windows-only PostgreSQL Maestro and EMS PostgreSQL manager.

pgAdmin III有问题，不能使用…嗯，软件，与windows的PostgreSQL Maestro和EMS PostgreSQL经理相比。

phpPgaAmin does not looks promising.

phpPgaAmin看起来并不乐观。

EMS PostgreSQL manager can work under Wine, but such setup have a number of issues.

EMS PostgreSQL manager可以在Wine下工作，但是这样的设置有很多问题。

Requirements are:

要求是:

1. Table data editing and browsing for large tables (1M+), able to jump by FK or some master-slave editing, GUI filtering and so on.
2. 表数据编辑和浏览大型表(1M+)，可以通过FK或一些主从编辑、GUI过滤等方式跳转。
3. ER diagrams with in-place schema editing
4. 具有就地模式编辑的ER图
5. Schema editing and browsing with all useful GUI support
6. 模式编辑和浏览所有有用的GUI支持
7. Schema changes log to put into DB versioning (migrations script).
8. 模式更改日志以放入DB版本控制(迁移脚本)。
9. Tabbed interface to be able to work with a number of tables and SQL queries at once.
10. 选项卡接口可以同时处理许多表和SQL查询。

And so on.

等等。

Any ideas?

什么好主意吗?

4 个解决方案

#1

Have you tried Squirrel SQL?

你试过Squirrel SQL吗?

http://squirrel-sql.sourceforge.net/

http://squirrel-sql.sourceforge.net/

#2

At the moment I suggest the use of DBeaver (http://dbeaver.jkiss.org/download/) that supports the Postgres and many other databases.

目前我建议使用DBeaver (http://dbeaver.jkiss.org/download/)支持Postgres和许多其他数据库。

[2016 update] Actually i'm using DataGrip https://www.jetbrains.com/datagrip/ is a tool developed by Intellij

[2016更新]实际上我正在使用的是一个由Intellij开发的工具DataGrip https://www.jetbrains.com/datagrip/

#3

Postgresql Tools

• Phppgadmin - I think you should reevaluate your outright dismissal of this tool. It has a larger feature set than PgAdmin III and allows you to connect over the local socket rather than strictly over the tcp port via JDBC.
• Phppgadmin -我认为你应该重新评估你对这个工具的彻底否定。它具有比PgAdmin III更大的特性集，允许您通过本地套接字连接，而不是严格地通过tcp端口通过JDBC连接。
• Aqua Data Studio - I used to use this tool quite often, but I'm unsure of its current status. It supports ER maps and has a number of features that are useful to developers.
• Aqua Data Studio——我以前经常使用这个工具，但是我不确定它的当前状态。它支持ER映射，并具有许多对开发人员有用的特性。

I doubt you will find everything that you want in a single tool. I a lot of development using Postgresql and I still find myself the most efficent with a nice text editor and the command line psql tool.

我怀疑你能否在一个工具中找到你想要的一切。我使用Postgresql进行了大量开发，我仍然发现自己是最有效的开发工具，有一个不错的文本编辑器和命令行psql工具。

#4

At the momen Navicat seems to produce the best admin tools for databases IMHO.

在momen Navicat似乎为IMHO提供了最好的管理工具。

Check out their free version (premium supporting multiple databases including postgres or just postgres version: ...for postgresql)

查看他们的免费版本(额外支持多个数据库，包括postgres或只是postgres版本:…)postgresql)

http://navicat.com/en/download/download.html

http://navicat.com/en/download/download.html