13

I used psql-command "\dp" to find out the given grants.

Versions on test-server: PostgreSQL 9.1.15 on armv7l-unknown-linux-gnueabi, compiled by gcc (Debian 4.6.3-14) 4.6.3, 32-bit

Out of the postgres-handbook:

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

When I fire up the command there is an additional plus-sign at the end of the acl-column (right after postgres). I could not find any documentation about it. 

postgres=# \dp test.*
                               Access privileges
 Schema | Name  | Type  |     Access privileges     | Column access privileges 
--------+-------+-------+---------------------------+--------------------------
 test   | films | table | postgres=arwdDxt/postgres+| code:                   +
        |       |       | =arwdDxt/postgres         |   candando=r/postgres

What is the plus sign about?

Markus
  • 300
  • 2
  • 6

1 Answers1

13

That plus sign is the indicator that the data spans more than one column. You'll get that with other multi-line values as well, not just the output of \dp