Catalogs: pg_namespace

48.31. pg_namespace

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 48-31. pg_namespace Columns

Name Type References Description
oid oid Row identifier (hidden attribute; must be explicitly selected)
nspname name Name of the namespace
nspowner oid pg_authid.oid Owner of the namespace
nspacl aclitem[] Access privileges; see GRANT and REVOKE for details

© 1996–2017 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.4/static/catalog-pg-namespace.html

在线笔记
App下载
App下载

扫描二维码

下载编程狮App

公众号
微信公众号

编程狮公众号

意见反馈
返回顶部