sudo -u postgres createuser -P app

Category: Databases & SQL

sudo -u postgres createuser -P app

Create a PostgreSQL role with password prompt

createuser wraps CREATE ROLE; -P prompts for the new role's password. Roles are cluster-wide, not per-database. Add --superuser, --createdb, or --login to grant extra attributes. Related: sudo -u postgres dropuser app.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.