Manage users in postgres database using psqlIn 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; Create a new user To create a new user, use the following command create user <user_name> with password ‘<password>’; Grant permission To grant permission, use the following command grant all on <database_name> to <user> Posted By - Karan Gupta Posted On - Monday, October 21, 2019 Query/Feedback Your Email Id Subject Query/Feedback Characters remaining 250
Manage users in postgres database using psql
select * from pg_user;
create user <user_name> with password ‘<password>’;
grant all on <database_name> to <user>
Query/Feedback