HiveBrain v1.2.0
Get Started
← Back to all entries
snippetbashTip

createuser — Create a PostgreSQL user (role). More information: <https://www.postgresql.org/docs/current/app-crea

Submitted by: @import:tldr-pages··
0
Viewed 0 times
createcommandcreateuserrolecliuserpostgresqlmore

Problem

How to use the createuser command: Create a PostgreSQL user (role). More information: <https://www.postgresql.org/docs/current/app-createuser.html>.

Solution

createuser — Create a PostgreSQL user (role). More information: <https://www.postgresql.org/docs/current/app-createuser.html>.

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}}

Code Snippets

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}}

Context

tldr-pages: common/createuser

Revisions (0)

No revisions yet.