欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜:Formal mathematics/Isabelle/ML, Formal verification/Coq/ACL2, C++/F#/Lisp
PhpPgAdmin
来自开放百科 - 灰狐
(版本间的差异)
第11行: | 第11行: | ||
apt-get install php5-pgsql | apt-get install php5-pgsql | ||
+ | http://localhost/phpPgAdmin-4.1/ | ||
+ | Login disallowed for security reasons. | ||
+ | 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; | ||
+ | |||
+ | vi /etc/postgresql/pg_hba.conf | ||
+ | |||
==相关链接== | ==相关链接== | ||
2007年3月21日 (三) 11:29的版本
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. 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; vi /etc/postgresql/pg_hba.conf
相关链接
精彩图集
分享您的观点