Privileges of Users

On 1/20/2011 11:56 PM, Adarsh Sharma wrote:

Dear all,

I want to know ACl of different users on different tables and databases
in Postgresql.
Is there any command as we do in mysql as :

select * from mysql.user\G;

I am researching but cannot able to find.

Thanks & Regards

Adarsh Sharma

use \dp in psql

-Andy

On 2011-01-21 16.16, Andy Colson wrote:

On 1/20/2011 11:56 PM, Adarsh Sharma wrote:

Dear all,

I want to know ACl of different users on different tables and databases
in Postgresql.
Is there any command as we do in mysql as :

select * from mysql.user\G;

I am researching but cannot able to find.

Thanks & Regards

Adarsh Sharma

use \dp in psql

And regarding the \G, it's for vertical output in mysql if I remember
correctly. The closest to this would be \x in psql.

-Andy

--
Regards,
Robert "roppert" Gravsjö