Обсуждение: Privileges of Users

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

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ö