PostgreSQL 18 · Databases and roles

Create a login role

Create a role that can sign in with a password. Use a real password.

CREATE ROLE app_user WITH LOGIN PASSWORD 'change-me';

Official PostgreSQL 18 documentation

More databases and roles commands

All databases and roles commands · PostgreSQL 18 cheatsheet

Was this page helpful?