Articles → POSTGRESQL → Manage users in postgres database using psql

Manage users in postgres database using psql

In this article, we will see how we can manage users in postgres database using psql.

Get the list of users on a database

We can use following command to get the list of all users

select 
  * 
from 
  pg_user;

To create a new user, use the following command

create user <user_name> with password ‘<password>’;

To grant permission, use the following command

grant all on <database_name> to <user>

Query/Feedback