On Apr 5, 2011, at 2:31 AM, Ray Stell wrote: > 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)
Following link contains detail about Access privileges: http://www.postgresql.org/docs/8.4/static/sql-grant.html 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 Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.ku...@enterprisedb.com Blog:http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
