系统表:
pg_shadow存放用户信息
pg_group 用户组的信息
1、create user username option
{with password ''
createdb | nocreatedb
createuser | nocreateuser
in group groupname
valid utill '2005-01-01'}
alter user username option
{with password ''
createdb | nocreatedb
createuser | nocreateuser
in group groupname
valid utill '2005-01-01'}
drop user username;
关于用户组
create group groupname option;
{with user user1,user2...}
example:
create group grp1;
create group grp2 with user user1,user2;
ALTER GROUP groupname ADD USER username [, ... ]
ALTER GROUP groupname DROP USER username [, ... ]
ALTER GROUP groupname RENAME TO newname
创建数据库
CREATE DATABASE name
[ [ WITH ] [ OWNER [=] dbowner ]
[ TEMPLATE [=] template ]
[ ENCODING [=] encoding ]
[ TABLESPACE [=] tablespace ] ]
例子:
创建一个新的数据库:
CREATE DATABASE lusiadas;
创建一个由用户 salesapp 所有的数据库 sales,缺省表空间是salesspace:
CREATE DATABASE sales OWNER salesapp TABLESPACE salesspace;
创建一个数据库 music,支持 ISO-8859-1 字符集:
CREATE DATABASE music ENCODING 'LATIN1';
删除:drop database databasename;
修改:
ALTER DATABASE name SET parameter { TO | = } { value | DEFAULT }
ALTER DATABASE name RESET parameter
ALTER DATABASE name RENAME TO newname
ALTER DATABASE name OWNER TO new_owner