SQL 类似于 phpMyAdmin 的 PostgreSQL 可视化界面?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/5725216/
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
PostgreSQL visual interface similar to phpMyAdmin?
提问by Tristan
I'd like to view and possibly edit tables for PostgreSQL visually like phpMyAdmin, where you can see the list of tables, and fields and individual rows for a table. Is there any utility that can do this?
我想像 phpMyAdmin 一样直观地查看和编辑 PostgreSQL 的表,您可以在其中查看表的列表、字段和表的各个行。有没有可以做到这一点的实用程序?
Forgive me if this is actually possible in pgAdmin III, but I couldn't figure out any way to see tables visually in pgAdmin. I have PostgreSQL 8.4 (I actually didn't install it myself, it was installed by another piece of software that utilizes it)
如果这在 pgAdmin III 中真的可行,请原谅我,但我想不出任何方法可以在 pgAdmin 中直观地查看表格。我有 PostgreSQL 8.4(实际上不是我自己安装的,它是由另一个使用它的软件安装的)
采纳答案by Peter Eisentraut
phpPgAdminmight work for you, if you're already familiar with phpMyAdmin.
如果您已经熟悉 phpMyAdmin,phpPgAdmin可能适合您。
Please note that development of phpPgAdmin has moved to githubper this noticebut the SourceForge link above is for historical / documentation purposes.
请注意,根据此通知,phpPgAdmin 的开发已移至 github,但上面的 SourceForge 链接用于历史/文档目的。
But really there are dozens of toolsthat can do this.
但实际上有很多工具可以做到这一点。
回答by Keith Palmer Jr.
I would also highly recommend Adminer - http://www.adminer.org/
我也强烈推荐 Adminer - http://www.adminer.org/
It is much faster than phpMyAdmin, does less funky iframe stuff, and supports both MySQL and PostgreSQL.
它比 phpMyAdmin 快得多,不那么时髦的 iframe 东西,并且支持 MySQL 和 PostgreSQL。
回答by Tyler Eaves
pgAdmin 4 is a powerful and popular web-based database management tool for PostgreSQL - http://www.pgadmin.org/
pgAdmin 4 是一个强大且流行的基于 Web 的 PostgreSQL 数据库管理工具 - http://www.pgadmin.org/