Re: [GENERAL] Privileges of Users

2011-01-21 Thread Robert Gravsjö 



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ö

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Privileges of Users

2011-01-21 Thread Andy Colson 

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Privileges of Users

2011-01-20 Thread Adarsh Sharma 

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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general