Skip to main content

Module pg_catalog

Module pg_catalog 

Source
Expand description

Built-in catalog items for the pg_catalog schema.

Constants§

TYPE_ACL_ITEM
TYPE_ACL_ITEM_ARRAY
TYPE_ANY
TYPE_ANYARRAY
TYPE_ANYCOMPATIBLE
TYPE_ANYCOMPATIBLEARRAY
TYPE_ANYCOMPATIBLENONARRAY
TYPE_ANYCOMPATIBLERANGE
TYPE_ANYELEMENT
TYPE_ANYNONARRAY
TYPE_ANYRANGE
TYPE_BOOL
TYPE_BOOL_ARRAY
TYPE_BPCHAR
TYPE_BPCHAR_ARRAY
TYPE_BYTEA
TYPE_BYTEA_ARRAY
TYPE_CHAR
TYPE_CHAR_ARRAY
TYPE_DATE
TYPE_DATE_ARRAY
TYPE_DATE_RANGE
TYPE_DATE_RANGE_ARRAY
TYPE_FLOAT4
TYPE_FLOAT8
TYPE_FLOAT4_ARRAY
TYPE_FLOAT8_ARRAY
TYPE_INT2
TYPE_INT4
TYPE_INT8
TYPE_INT2_ARRAY
TYPE_INT2_VECTOR
TYPE_INT2_VECTOR_ARRAY
TYPE_INT4_ARRAY
TYPE_INT4_RANGE
TYPE_INT4_RANGE_ARRAY
TYPE_INT8_ARRAY
TYPE_INT8_RANGE
TYPE_INT8_RANGE_ARRAY
TYPE_INTERNAL
TYPE_INTERVAL
TYPE_INTERVAL_ARRAY
TYPE_JSONB
TYPE_JSONB_ARRAY
TYPE_NAME
TYPE_NAME_ARRAY
TYPE_NUMERIC
TYPE_NUMERIC_ARRAY
TYPE_NUM_RANGE
TYPE_NUM_RANGE_ARRAY
TYPE_OID
TYPE_OID_ARRAY
TYPE_RECORD
TYPE_RECORD_ARRAY
TYPE_REGCLASS
TYPE_REGCLASS_ARRAY
TYPE_REGPROC
TYPE_REGPROC_ARRAY
TYPE_REGTYPE
TYPE_REGTYPE_ARRAY
TYPE_TEXT
TYPE_TEXT_ARRAY
TYPE_TIME
TYPE_TIMESTAMP
TYPE_TIMESTAMPTZ
TYPE_TIMESTAMPTZ_ARRAY
TYPE_TIMESTAMP_ARRAY
TYPE_TIME_ARRAY
TYPE_TSTZ_RANGE
TYPE_TSTZ_RANGE_ARRAY
TYPE_TS_RANGE
TYPE_TS_RANGE_ARRAY
TYPE_UUID
TYPE_UUID_ARRAY
TYPE_VARCHAR
TYPE_VARCHAR_ARRAY

Statics§

PG_ACCESS_METHODS
PG_AGGREGATE
PG_ATTRDEF
PG_ATTRIBUTE
https://www.postgresql.org/docs/current/catalog-pg-attribute.html
PG_AUTHID
PG_AUTH_MEMBERS
PG_CLASS
PG_COLLATION
PG_CONSTRAINT
PG_DATABASE
PG_DEPEND
PG_DESCRIPTION
Note: Databases, Roles, Clusters, Cluster Replicas, Secrets, and Connections are excluded from this view for Postgres compatibility. Specifically, there is no classoid for these objects, which is required for this view.
PG_ENUM
PG_EVENT_TRIGGER
PG_EXTENSION
PG_INDEX
PG_INDEXES
PG_INHERITS
PG_LANGUAGE
PG_LOCKS
PG_MATVIEWS
PG_NAMESPACE
PG_OPERATOR
PG_POLICY
PG_PROC
PG_RANGE
PG_REWRITE
PG_ROLES
PG_SETTINGS
PG_SHDESCRIPTION
PG_TABLES
PG_TABLESPACE
PG_TIMEZONE_ABBREVS
PG_TIMEZONE_NAMES
PG_TRIGGER
PG_TYPE
PG_USER
PG_VIEWS