1CREATE USER()                    SQL Commands                    CREATE USER()
2
3
4

NAME

6       CREATE USER - define a new database role
7
8

SYNOPSIS

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

DESCRIPTION

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

COMPATIBILITY

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

SEE ALSO

42       CREATE ROLE [create_role(7)]
43
44
45
46SQL - Language Statements         2008-06-08                     CREATE USER()