Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyAdvanced PostgreSQL

Create a new Role (User)

SQL

CREATE ROLE app_user WITH LOGIN PASSWORD 'secure_pass';

Tested against PostgreSQL 16

Note

“Roles can be users or groups. WITH LOGIN makes it a user account.