CREATE GROUP 中文man頁面
NAME
CREATE GROUP - 定義一個新的用戶組
SYNOPSIS
CREATE GROUP name [ [ WITH ] option [ ... ] ] where option can be: SYSID gid | USER username [, ...]
DESCRIPTION 描述
CREATE GROUP 將在數據庫集群上創建一個新組。 要使用這條命令,你必須是數據庫超級用戶。
使用 ALTER GROUP [alter_group(7)] 修改組成員,DROP GROUP [drop_group(7)] 刪除一個組。
PARAMETERS 參數
- name
- 組名。
- gid
- SYSID 子句可以用于選擇 PostgreSQL 里新組的組標識(group ID)。 不過,這樣做不是必須的。
如果沒有聲明這個,將使用從 1 開始的,已分配的最高組標識加一作為缺省值。 - username
包括到組里面的用戶列表。用戶必須已經存在。
EXAMPLES 例子
創建一個空組:
CREATE GROUP staff;
創建一個有成員的組:
CREATE GROUP marketing WITH USER jonathan, david;
#p#
NAME
CREATE GROUP - define a new user group
SYNOPSIS
CREATE GROUP name [ [ WITH ] option [ ... ] ] where option can be: SYSID gid | USER username [, ...]
DESCRIPTION
CREATE GROUP will create a new group in the database cluster. You must be a database superuser to use this command.
Use ALTER GROUP [alter_group(7)] to change a group's membership, and DROP GROUP [drop_group(7)] to remove a group.
PARAMETERS
- name
- The name of the group.
- gid
- The SYSID clause can be used to choose the PostgreSQL group ID of the new group. It is not necessary to do so, however.
If this is not specified, the highest assigned group ID plus one, starting at 1, will be used as default.
- username
- A list of users to include in the group. The users must already exist.
EXAMPLES
Create an empty group:
CREATE GROUP staff;
Create a group with members:
CREATE GROUP marketing WITH USER jonathan, david;