Postgresql 中文操作指南

CREATE GROUP

CREATE GROUP——定义新的数据库角色

CREATE GROUP — define a new database role

Synopsis

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

where option can be:

      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | REPLICATION | NOREPLICATION
    | BYPASSRLS | NOBYPASSRLS
    | CONNECTION LIMIT connlimit
    | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL
    | VALID UNTIL 'timestamp'
    | IN ROLE role_name [, ...]
    | IN GROUP role_name [, ...]
    | ROLE role_name [, ...]
    | ADMIN role_name [, ...]
    | USER role_name [, ...]
    | SYSID uid

Description

CREATE GROUP 现在是 CREATE ROLE 的别名。

CREATE GROUP is now an alias for CREATE ROLE.

Compatibility

SQL 标准中没有 CREATE GROUP 语句。

There is no CREATE GROUP statement in the SQL standard.

See Also

CREATE ROLE

CREATE ROLE