| Role name | Super user? | Inherit? | Create role? | Create DB? | Catalog update? | Can login? | Connection limits | Valid until | Configuration |
| admin | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
-1 | ||
| albert | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
-1 | ||
| dalibo | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
-1 | {default_tablespace=toto} | |
| guillaume | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
-1 | ||
| juliette | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
-1 | ||
| melanie | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
-1 | ||
| postgres | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
-1 | ||
| romain | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
-1 |
SELECT rolname, rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcatupdate, rolcanlogin, rolconnlimit, rolvaliduntil, rolconfig FROM pg_roles ORDER BY rolname