createuser

User Management

Create a new PostgreSQL user

Options & Flags

Available options for this command

-s

Create superuser

-d

Allow user to create databases

-r

Allow user to create roles

-P

Prompt for password

-l

Allow user to login (default)

Examples

Common usage examples

Create basic user

createuser myuser

Create user with password prompt

createuser -P myuser

Create superuser

createuser -s admin

Create user who can create databases

createuser -d developer

Notes

Equivalent to CREATE ROLE with LOGIN

Related Commands

You might also find these useful