This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a command of PSQL for getting the list of privileges of a database in PostgreSQL.
PSQL is a handy tool for PostgreSQL DBAs and they are always preferring to use a command line tool.
This article is for PostgreSQL beginner who is looking for the list of privileges in PostgreSQL.
How to connect the database in PSQL?
1 |
-psql>\connect database_name |
Get the list of databases:
1 2 3 |
-psql> \list or -psql> \l |
Get the list of privileges:
1 |
-psql> \du |
Leave a Reply