pgAdmin 和 PostgreSQL 的区别

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/38703378/
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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-10-21 02:21:19  来源:igfitidea点击:

Difference between pgAdmin and PostgreSQL

postgresqlpgadmin

提问by Martin Strejc

Can someone tell me the difference between pgAdmin and postgreSQL? Are both of them one in the same? I can't draw a ER diagram in pgAdmin but was wondering if it's possible in postgreSQL?

有人能告诉我 pgAdmin 和 postgreSQL 之间的区别吗?两者是同一个吗?我无法在 pgAdmin 中绘制 ER 图,但想知道在 postgreSQL 中是否可行?

Once I downloaded the postgreSQL it automatically downloaded the pgAdmin and the postgreSQL database is not in sight.

一旦我下载了 postgreSQL,它就会自动下载 pgAdmin,并且看不到 postgreSQL 数据库。

回答by Sampad

PostgreSQL (pronounced as post-gress-Q-L) is an open source relational database management system ( DBMS ) developed by a worldwide team of volunteers. PostgreSQL is not controlled by any corporation or other private entity and the source code is available free of charge.

The pgAdmin package is a free and open source graphical user interface administration tool for PostgreSQL, which is supported on many computer platforms.

phpPgAdminis a web-based administration tool for PostgreSQL written in PHP and based on the popular phpMyAdmininterface originally written for MySQL administration

Hope you can understand now it well!!

PostgreSQL(发音为 post-gress-QL)是一个由全球志愿者团队开发的开源关系数据库管理系统 (DBMS)。PostgreSQL 不受任何公司或其他私人实体的控制,并且源代码是免费提供的。

pgAdmin 软件包是 PostgreSQL 的免费开源图形用户界面管理工具,在许多计算机平台上都受支持。

phpPgAdmin是一个基于 Web 的 PostgreSQL 管理工具,用 PHP 编写,基于流行的phpMyAdmin界面,最初是为 MySQL 管理编写的

希望你现在能理解它了!!

回答by Martin Strejc

The PostgreSQL is a database engine implementing SQL standards. It usually listen as a server on a network tcp port to provide its abilities.

PostgreSQL 是一个实现 SQL 标准的数据库引擎。它通常在网络 tcp 端口上作为服务器侦听以提供其功能。

The pgAdmin is a sort of client. You are able to manipulate schema and data on an instance or multiple instances of PostgreSQL engines.

pgAdmin 是一种客户端。您可以在 PostgreSQL 引擎的一个或多个实例上操作模式和数据。

The MS Windows instalation package consists of both PostgreSQL server and PgAdmin client. So far right after the instalation you are able to manage your databases.

MS Windows 安装包由 PostgreSQL 服务器和 PgAdmin 客户端组成。到目前为止,在安装之后您就可以管理您的数据库了。