show users;

From wikieduonline
Jump to navigation Jump to search

show users


postgres=# \du
                                      List of roles
   Role name    |                         Attributes                         | Member of
----------------+------------------------------------------------------------+-----------
 YOUR_USER      | Create DB                                                  | {}
 postgres       | Superuser, Create role, Create DB, Replication, Bypass RLS | {}


  • create role USERNAME with login password 'PASSWORD';
  • create database DATABASE_NAME owner USERNAME;

Related terms[edit]

See also[edit]

Advertising: