PostgreSQL 管理器
我从 6.5 开始就一直使用 Microsoft SQL Server 以及其他数据库,如 Oracle、MySQL 和 SQLite。在某些方面,我同样欣赏或讨厌所有这些 DBMS。
在我们即将推出的项目中,我们正在考虑在后端使用 Postgres。我已经开始玩它了,对我来说非常有趣。
我一直听到关于 Postgres 数据库的好评,但我一点也不喜欢 admin studio。在创建新表时,我讨厌在 pgAdmin 上创建列的方式,必须一次又一次单击“添加”按钮。
Postgres 数据库是否有任何“工作室”可以提供
- 更有组织的表创建过程(类似电子表格)
- 图形视图设计器
I have been working with Microsoft SQL Server since 6.5 along with other database like Oracle, MySQL and SQLite. I equally appreciate or hate all these DBMS for some point or the other.
On our forthcoming project, we are considering Postgres in the back-end. I have already started playing with it, pretty interesting for me.
I have always heard good comments on Postgres database, but I don't like the admin studio at all. While creating new a table, I hate the way of creating columns on pgAdmin by having to click add button again and again.
Are there any "Studios" for Postgres database that provide
- more organized table creation process (spreadsheet like)
- graphical view designer
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
普通 SQL 有什么问题?编写纯 SQL 比单击-等待-单击-等待-类型-单击-等待-确定-等待要快得多。您可以使用任何工具来完成此操作,例如 pgAdmin。
Open Office Base 还可以与 PostgreSQL 连接,就像 MS Access 一样。说到MS Access,MS Access还可以连接到PostgreSQL来创建表、视图等。
What's wrong with plain SQL? Writing plain SQL goes much faster than click-wait-click-wait-type-click-wait-ok-wait. You could use any tool for this, pgAdmin as well.
Open Office Base can also connect with PostgreSQL, works like MS Access. And talking about MS Access, MS Access can also connect to PostgreSQL to create tables, views, etc.
请参阅此官方管理/开发工具列表。
EMS SQL Manager 似乎是一个不错的选择。
See this official list of Administration/Development tools.
EMS SQL Manager seems to be a good option.
用于 SQL 查询的图形视图
也许 SQLeo 可以提供帮助
for the graphical view of SQL queries
maybe SQLeo can Help