1CREATE USER(7)           PostgreSQL 15.4 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. The only difference is
32       that when the command is spelled CREATE USER, LOGIN is assumed by
33       default, whereas NOLOGIN is assumed when the command is spelled CREATE
34       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 15.4                      2023                       CREATE USER(7)
Impressum