PhpPgAdmin

phpPgAdmin是一个让你通过网络对你的PostgreSQL进行管理的工具，也是使用PHP语言编写，支持多国语言(含简、繁中文)等多国语言，支持PostgreSQL v7.0.x, v7.1.x, v7.2.x, v7.3.x, v7.4.x, v8.0.x and v8.1.x

基本功能

和phpmyadmin几乎一样

安装指南

PHP using the --with-pgsql

针对 Debian 用户

apt-get install php4-pgsql
apt-get install php5-pgsql 

http://localhost/phpPgAdmin-4.1/
Login disallowed for security reasons.
http://phppgadmin.sourceforge.net/?page=faq

psql mydb
mydb=# create user huihoo;
mydb=# alter user huihoo with password 'huihoo';
mydb=# \d
public | cities  | table | postgres
public | myview  | view  | postgres
public | sal_emp | table | postgres
public | weather | table | postgres

mydb=# grant all on sal_emp to huihoo;
mydb=# grant all on cities to huihoo;
mydb=# grant all on weather to huihoo;

mydb=# \q
psql -U huihoo -d mydb

vi /etc/postgresql/pg_hba.conf
host all all 127.0.0.1 255.255.255.255 trust
and 
vi conf/config.inc.php
$conf['extra_login_security'] = false;

/etc/init.d/postgresql restart
http://localhost/phpPgAdmin-4.1/
huihoo/huihoo :) 

相关链接

• 官方网站 - http://phppgadmin.sourceforge.net/
• 下载 - http://phppgadmin.sourceforge.net/?page=download

精彩图集