1CREATE USER(7)           PostgreSQL 12.6 Documentation          CREATE USER(7)
2
3
4

NAME

6       CREATE_USER - define a new database role
7

SYNOPSIS

9       CREATE USER name [ [ WITH ] option [ ... ] ]
10
11       where option can be:
12
13             SUPERUSER | NOSUPERUSER
14           | CREATEDB | NOCREATEDB
15           | CREATEROLE | NOCREATEROLE
16           | INHERIT | NOINHERIT
17           | LOGIN | NOLOGIN
18           | REPLICATION | NOREPLICATION
19           | BYPASSRLS | NOBYPASSRLS
20           | CONNECTION LIMIT connlimit
21           | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL
22           | VALID UNTIL 'timestamp'
23           | IN ROLE role_name [, ...]
24           | IN GROUP role_name [, ...]
25           | ROLE role_name [, ...]
26           | ADMIN role_name [, ...]
27           | USER role_name [, ...]
28           | SYSID uid
29

DESCRIPTION

31       CREATE USER is now an alias for CREATE ROLE (CREATE_ROLE(7)). The only
32       difference is that when the command is spelled CREATE USER, LOGIN is
33       assumed by default, whereas NOLOGIN is assumed when the command is
34       spelled CREATE ROLE.
35

COMPATIBILITY

37       The CREATE USER statement is a PostgreSQL extension. The SQL standard
38       leaves the definition of users to the implementation.
39

SEE ALSO

41       CREATE ROLE (CREATE_ROLE(7))
42
43
44
45PostgreSQL 12.6                      2021                       CREATE USER(7)
Impressum