schema access privs

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: schema access privs
Date: 2011-04-04 21:01:49
Message-ID: 20110404210149.GA30991@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What does the results in col 'List of schemas Access privileges'
indicate? Are those three results split by the '/' char? What
are the three sections? What is 'postgres+'

Can't find this explained in the docs.

template1-# \dn+ pg_catalog
List of schemas
Name | Owner | Access privileges | Description
------------+----------+----------------------+-----------------------
pg_catalog | postgres | postgres=UC/postgres+| system catalog schema
| | =U/postgres |
(1 row)

http://www.postgresql.org/docs/current/static/app-psql.html

\dn[+] [ pattern ]

Lists schemas (namespaces). If pattern is specified, only schemas
whose names match the pattern are listed. Non-local temporary schemas
are suppressed. If + is appended to the command name, each object
is listed with its associated permissions and description, if any.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-04-04 21:12:28 Re: scary xpath_table behaviour
Previous Message John R Pierce 2011-04-04 20:32:24 Re: ..horribly documented, inefficient, user-hostile, impossible to maintain interpreted language..