Name

Synopsis

CREATE USERname [ [ WITH ]option [ ... ] ]whereoption can be:      SUPERUSER | NOSUPERUSER    | CREATEDB | NOCREATEDB    | CREATEROLE | NOCREATEROLE    | CREATEUSER | NOCREATEUSER    | INHERIT | NOINHERIT    | LOGIN | NOLOGIN    | REPLICATION | NOREPLICATION    | CONNECTION LIMITconnlimit    | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'    | VALID UNTIL 'timestamp'    | IN ROLErole_name [, ...]    | IN GROUProle_name [, ...]    | ROLErole_name [, ...]    | ADMINrole_name [, ...]    | USERrole_name [, ...]    | SYSIDuid

Description

CREATE USER is now an alias forCREATE ROLE. The only difference is that when the command is spelledCREATE USER,LOGIN is assumed by default, whereasNOLOGIN is assumed when the command is spelledCREATE ROLE.

Compatibility

TheCREATE USER statement is aPostgreSQL extension. The SQL standard leaves the definition of users to the implementation.

See Also