[prev] 69 [next]

Representing Databases (cont)

pg_database contains information about databases:
  • oid, datname, datdba, datacl[], encoding, ...
pg_namespace contains information about schemata:
  • oid, nspname, nspowner, nspacl[]
pg_tablespace contains information about tablespaces:
  • oid, spcname, spcowner, spcacl[]
PostgreSQL represents access via array of access items: 

Role=Privileges/Grantor

where Privileges is a string enumerating privileges, e.g. 

jas=arwdRxt/jas,fred=r/jas,joe=rwad/jas