createuser

all

Create a PostgreSQL user (role).

Options (6)

-s, --superuserboolean

Create a superuser

Example: createuser {{[-s|--superuser]}} {{username}}

-d, --createdbboolean

Create a user allowed to create databases, manage roles, and prompt for a password

Example: createuser {{[-d|--createdb]}} {{[-r|--createrole]}} {{[-P|--pwprompt]}} {{username}}

-r, --createroleboolean

Create a user allowed to create databases, manage roles, and prompt for a password

Example: createuser {{[-d|--createdb]}} {{[-r|--createrole]}} {{[-P|--pwprompt]}} {{username}}

-P, --pwpromptboolean

Create a user allowed to create databases, manage roles, and prompt for a password

Example: createuser {{[-d|--createdb]}} {{[-r|--createrole]}} {{[-P|--pwprompt]}} {{username}}

-D, --no-createdbboolean

Create a user without the ability to create databases or manage roles

Example: createuser {{[-D|--no-createdb]}} {{[-R|--no-createrole]}} {{username}}

-R, --no-createroleboolean

Create a user without the ability to create databases or manage roles

Example: createuser {{[-D|--no-createdb]}} {{[-R|--no-createrole]}} {{username}}

Create a user interactively

createuser --interactive username

Create a user with no special rights

createuser username

Create a superuser

createuser [-s|--superuser] username

Create a user allowed to create databases, manage roles, and prompt for a password

createuser [-d|--createdb] [-r|--createrole] [-P|--pwprompt] username

Create a user without the ability to create databases or manage roles

createuser [-D|--no-createdb] [-R|--no-createrole] username