show users;

From wikieduonline
(Redirected from Show users)
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]