CREATE GROUP

An SQL command for defining a role

CREATE GROUP is a historical DDL command for defining a role.

CREATE GROUP was added in PostgreSQL 7.0; since PostgreSQL 8.1 it has been an alias for CREATE ROLE.

Change history

PostgreSQL 10
- option UNENCRYPTED PASSWORD removed (eb61136d)
PostgreSQL 9.6
- option CREATEUSER/NOCREATEUSER removed (commit d371bebd)
PostgreSQL 9.5
- option BYPASSRLS/NOBYPASSRLS added (commit 491c029d)
- CURRENT_USER and SESSION_USER are now accepted in place of a user name (commit 31eae602)
PostgreSQL 9.1
- option REPLICATION/NOREPLICATION added (commit 9b8aff8c)
PostgreSQL 8.1
- alias for CREATE ROLE (commit 7762619e)
PostgreSQL 7.0
- added (commit 99b8f845)

Basic usage example for CREATE GROUP:

postgres=# CREATE GROUP bar;
CREATE ROLE

Note that as CREATE GROUP is an alias for CREATE ROLE, usage such as the following is possible, if somewhat counterintuitive:

postgres=# CREATE GROUP foo;
CREATE ROLE

postgres=# ALTER USER foo LOGIN ;
ALTER ROLE