Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Understanding the output of PSQL's \dp and \z

I'm having trouble selecting from a database in PSQL. This is the output of the table I'm interested in. Can someone decipher the access priveleges for me? I know that arwdRxt means append,read,write,etc... The syntax is confusing to me, what exactly do the slashes and equals mean in the access privileges column? Please let me know if my question isn't clear.

                    Access privileges
 schema |     name      | type |    access privileges    
--------+---------------+------+-------------------------
 public | table_name    | view | amazonuser=arwdRxt/amazonuser+
        |               |      | readonly=r/amazonuser
like image 589
user2588667 Avatar asked Dec 26 '22 17:12

user2588667


1 Answers

It is described in detail in the docs. The thing before the = is who has those permissions, the thing after the / is who granted those permissions.

like image 165
jjanes Avatar answered Jan 18 '23 04:01

jjanes