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.
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.. |