| 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