PostgreSQL 7.4.30 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Chapter 43. System Catalogs | Fast Forward | Next |
The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection of relations, types, etc. without name conflicts.
Table 43-21. pg_namespace Columns
Name | Type | References | Description |
---|---|---|---|
nspname | name | Name of the namespace | |
nspowner | int4 | pg_shadow.usesysid | Owner of the namespace |
nspacl | aclitem[] | Access privileges |