PostgreSQL 9.0.4 中文文档
PrevFast BackwardFast ForwardNext

CREATE GROUP

Name

CREATE GROUP -- 定义一个新数据库角色

Synopsis

CREATE GROUP name [ [ WITH ] option [ ... ] ]

这里option可以是：
    
      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | CREATEUSER | NOCREATEUSER
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
    | VALID UNTIL 'timestamp' 
    | IN ROLE role_name [, ...]
    | IN GROUP role_name [, ...]
    | ROLE role_name [, ...]
    | ADMIN role_name [, ...]
    | USER role_name [, ...]
    | SYSID uid

描述

CREATE GROUP现在是CREATE ROLE的别名。

兼容性

SQL标准里没有CREATE GROUP语句。

又见

CREATE ROLE
PrevHomeNext
CREATE FUNCTIONUpCREATE INDEX