| PostgreSQL 8.2.6 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Fast Forward | Next | |
CREATE USER
name
[ [ WITH ]
option
[ ... ] ] where
option
can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | CONNECTION LIMIT
connlimit
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD '
password
' | VALID UNTIL '
timestamp
' | IN ROLE
rolename
[, ...] | IN GROUP
rolename
[, ...] | ROLE
rolename
[, ...] | ADMIN
rolename
[, ...] | USER
rolename
[, ...] | SYSID
uid
CREATE USER is now an alias for CREATE ROLE . The only difference is that when the command is spelled CREATE USER , LOGIN is assumed by default, whereas NOLOGIN is assumed when the command is spelled CREATE ROLE .
The CREATE USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.