createuser

Create a user interactively

$ createuser [username]

$ createuser -s [username]

$ createuser -P [username]

$ createuser -d [username]

$ createuser -h [localhost] -p [5432] -U [admin] [username]

$ createuser -r [username]

createuser [options] [username]

createuser is a PostgreSQL utility that creates new database users (roles). It's a wrapper around the SQL CREATE ROLE command, providing a convenient command-line interface.
The tool can create users with various privileges including superuser status, database creation rights, and role creation abilities. It connects to the database server and executes the appropriate SQL.

-s, --superuser

Create superuser.

Allow creating databases.

Allow creating roles.

Allow login (default).

Prompt for password.

Show generated SQL.

Database server host.

Database server port.

Connect as user.

Force password prompt.

Role inherits privileges.

Allow replication connections.

Requires appropriate privileges to create roles. Superuser creation requires superuser connection. Password set via -P is entered interactively.

createuser has been part of PostgreSQL since early versions, providing a shell interface to role management. PostgreSQL evolved from the POSTGRES project at UC Berkeley in the 1980s. The distinction between users and roles was unified in PostgreSQL 8.1.

dropuser(1), psql(1), createdb(1), pg_dump(1)