Difference between revisions of "\dp"

From wikieduonline
Jump to navigation Jump to search
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
[[Lists tables]], views and sequences with their associated access [[privileges]]:
 
  \dp
 
  \dp
 
  \dp *.*
 
  \dp *.*
 +
  
 
   
 
   
Line 11: Line 13:
  
  
 +
TABLE (and table-like objects) arwdDxt none \dp
 +
 +
 +
https://www.postgresql.org/docs/9.3/sql-grant.html
 +
<pre>
 +
rolename=xxxx -- privileges granted to a role
 +
        =xxxx -- privileges granted to PUBLIC
 +
 +
            r -- SELECT ("read")
 +
            w -- UPDATE ("write")
 +
            a -- INSERT ("append")
 +
            d -- DELETE
 +
            D -- TRUNCATE
 +
            x -- REFERENCES
 +
            t -- TRIGGER
 +
            X -- EXECUTE
 +
            U -- USAGE
 +
            C -- CREATE
 +
            c -- CONNECT
 +
            T -- TEMPORARY
 +
      arwdDxt -- ALL PRIVILEGES (for tables, varies for other objects)
 +
            * -- grant option for preceding privilege
 +
 +
        /yyyy -- role that granted this privilege
 +
</pre>
  
  
 
== Related ==
 
== Related ==
 
* [[List tables]]: <code>[[\dt]]</code>
 
* [[List tables]]: <code>[[\dt]]</code>
 +
* [[List schemas]]: <code>[[\dn]]</code>
 
* [[sequence]], [[table]]
 
* [[sequence]], [[table]]
 
* [[views]]
 
* [[views]]
 +
* <code>[[\ddp]]</code>
 +
* [[Access Control Lists (ACL)]]
 +
* <code>[[\du]]</code>
  
 
== See also ==
 
== See also ==

Latest revision as of 11:56, 16 December 2022

Lists tables, views and sequences with their associated access privileges:

\dp
\dp *.*


\dp
                                                            Access privileges
Schema |                   Name                   |   Type   |              Access privileges              | Column privileges | Policies
--------+------------------------------------------+----------+---------------------------------------------+-------------------+----------


TABLE (and table-like objects)	arwdDxt	none	\dp


https://www.postgresql.org/docs/9.3/sql-grant.html

rolename=xxxx -- privileges granted to a role
        =xxxx -- privileges granted to PUBLIC

            r -- SELECT ("read")
            w -- UPDATE ("write")
            a -- INSERT ("append")
            d -- DELETE
            D -- TRUNCATE
            x -- REFERENCES
            t -- TRIGGER
            X -- EXECUTE
            U -- USAGE
            C -- CREATE
            c -- CONNECT
            T -- TEMPORARY
      arwdDxt -- ALL PRIVILEGES (for tables, varies for other objects)
            * -- grant option for preceding privilege

        /yyyy -- role that granted this privilege


Related[edit]

See also[edit]

Advertising: