欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜：Formal mathematics/Isabelle/ML, Formal verification/Coq/ACL2, C++/F#/Lisp
PhpPgAdmin
来自开放百科 - 灰狐
（版本间的差异）
小 (已恢复94.23.1.28（讨论）的编辑至Allen的最后一个修订版本) |
|||
| （未显示4个用户的15个中间版本） | |||
| 第1行： | 第1行： | ||
| + | {{top news}} | ||
| + | {{SeeWikipedia}} | ||
| + | |||
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 | 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 | ||
| 第11行： | 第14行： | ||
apt-get install php5-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['servers'][0]['host'] = '127.0.0.1'; | ||
| + | $conf['extra_login_security'] = false; | ||
| + | |||
| + | /etc/init.d/postgresql restart | ||
| + | http://localhost/phpPgAdmin-4.1/ | ||
| + | huihoo/huihoo | ||
| + | PostgreSQL 7.4.7 running on 127.0.0.1:5432 -- You are logged in as user "huihoo" :) | ||
| + | |||
==相关链接== | ==相关链接== | ||
| 第17行： | 第52行： | ||
==精彩图集== | ==精彩图集== | ||
| − | + | <gallery perrow=6> | |
| + | Image:phppgadmin-01.png | ||
| + | Image:phppgadmin-02.png | ||
| + | Image:phppgadmin-03.png|Viewing a database | ||
| + | Image:phppgadmin-04.png|Exporting a database | ||
| + | Image:phppgadmin-05.png|Searching for database objects | ||
| + | Image:phppgadmin-06.png|Viewing a table's structure | ||
| + | </gallery> | ||
| + | |||
| + | {{Comment}} | ||
| + | |||
| + | [[Category:Database]] | ||
| + | [[Category:PostgreSQL]] | ||
| + | [[Category:PHP]] | ||
2012年10月29日 (一) 07:30的最后版本
|
您可以在Wikipedia上了解到此条目的英文信息 PhpPgAdmin Thanks, Wikipedia. |
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['servers'][0]['host'] = '127.0.0.1'; $conf['extra_login_security'] = false;
/etc/init.d/postgresql restart http://localhost/phpPgAdmin-4.1/ huihoo/huihoo PostgreSQL 7.4.7 running on 127.0.0.1:5432 -- You are logged in as user "huihoo" :)
[编辑] 相关链接
[编辑] 精彩图集
Viewing a database
Exporting a database
Searching for database objects
Viewing a table's structure
<discussion>characters_max=300</discussion>
分享您的观点
