PgAdmin

pgAdmin : PostgreSQL administration and management tools

简介

• pgAdmin 4 is written in Python and jQuery with Bootstrap, using the Flask framework.
• pgAdmin III 使用 C++ 和 wxWidgets 框架开发。

安装

OS X用户

brew info postgresql
brew install postgresql
postgres -D /usr/local/var/postgres &

Debian用户

vi /etc/apt/sources.list 
deb [MIRROR URL]/pgadmin3/release/debian sarge pgadmin For example,
deb ftp://ftp.hk.postgresql.org/postgresql/pgadmin3/release/debian/ sarge pgadmin 
apt-get update
apt-get install pgadmin3

Ubuntu

sudo apt-get install pgadmin3

Web

wget https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl
pip install ./pgadmin4-1.3-py2.py3-none-any.whl
python ~/pgadmin4/lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
http://127.0.0.1:5050

图集

• 

  pgAdmin 4

• 

  pgAdmin 3

链接

• PgAdmin官网