PostgreSQL: Database roles

• https://www.postgresql.org/docs/current/database-roles.html

Create role:

• create role

List users and roles:

• \du
• \du+
• SELECT rolname FROM pg_roles;
• SELECT * FROM pg_roles;

Related terms

• CREATE ROLE, create user
• Schema
• GRANT privileges to roles
• Superuser
• rds_superuser role in AWS RDS
• Ansible roles

See also

• PostgreSQL: Database roles, CREATE USER, CREATE ROLE, \du, \du+, create user, Alter user
• SQL, NewSQL, RDMS: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint, .sql