当前页面位置: » 丰搜网 » 文档中心 » 详细内容
第十章 linux postgresql database 服务器(二)
命令
安装到系统中的文件
命令
下面列出的是一些我们经常要用到的命令，当然还有很多其它的命令，更详细的信息可以查看man帮助页或其它文档。
在"pg_hba.conf"文件的pg_data段可以用ip地址和用户名限制对能数据库的连接。
l 用“createuser”命令在数据库中定义一个新用户：
[root@deep]# su postgres
[postgres@deep]$ createuser
enter name of user to add ---> admin
enter user's postgres id or return to use unix user id: 500 ->
is user "admin" allowed to create databases (y/n) y
is user "admin" a superuser? (y/n) y
createuser: admin was successfully added
l 用“destroyuser”命令在数据库中删除用户：
[root@deep]# su postgres
[postgres@deep]$ destroyuser
enter name of user to delete ---> admin
destroyuser: delete of user admin was successful.
l 用“createdb”命令创建新的数据库：
[root@deep]# su postgres
[postgres@deep]$ createdb dbname (the name of the database).
也可以用postgres的终端程序（psql）完成：
[root@deep]# su admin
[admin@deep]$ psql template1
welcome to the postgresql interactive sql monitor:
please read the file copyright for copyright terms of postgresql
[postgresql 6.5.3 on i686-pc-linux-gnu, compiled by egcs ]
type ? for help on slash commands
type q to quit
type g or terminate with semicolon to execute query
you are currently connected to the database: template1
template1 è create database foo;
createdb
其它一些有用的终端程序（psql）命令：
l 连接到另外的数据库：
template1 è c foo
connecting to new database: foo
foo è
l 创建一个表：
foo è create table bar (i int4, c char(16));
create
foo è
l 检查新表：
foo è d bar
table = bar
+-------+--------+--------+
field type length
+-------+--------+--------+
i int4 4
c char() 16
+-------+--------+--------+
foo è
l 删除表、索引、视图：
foo è drop table table_name;
foo è drop index index_name;
foo è drop view view_name;
l 往一个表里插入记录：
foo è insert into table_name (name_of_attr1, name_of_attr2, name_of_attr3)
foo è values (value1, value2, value3);
安装到系统中的文件
> /etc/rc.d/init.d/postgresql
> /etc/rc.d/rc0.d/k15postgresql
> /etc/rc.d/rc1.d/k15postgresql
