roleid

oid

``.oid

具有成員的角色 ID

member

oid

.oid

作為 roleid 成員的角色 ID

grantor

oid

``.oid

授予此成員資格的角色 ID

admin_option

bool

如果成員可以將 roleid 的成員資格授予其他人，則為 True

Column Type

Description

oid oid

Row identifier

relname name

Name of the table, index, view, etc.

The OID of the namespace that contains this relation

The OID of the data type that corresponds to this table's row type, if any (zero for indexes, which have no pg_type entry)

For typed tables, the OID of the underlying composite type, zero for all other relations

Owner of the relation

If this is a table or an index, the access method used (heap, B-tree, hash, etc.)

relfilenode oid

Name of the on-disk file of this relation; zero means this is a “mapped” relation whose disk file name is determined by low-level state

The tablespace in which this relation is stored. If zero, the database's default tablespace is implied. (Not meaningful if the relation has no on-disk file.)

relpages int4

Size of the on-disk representation of this table in pages (of size BLCKSZ). This is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX.

reltuples float4

Number of live rows in the table. This is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX.

relallvisible int4

Number of pages that are marked all-visible in the table's visibility map. This is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX.

OID of the TOAST table associated with this table, 0 if none. The TOAST table stores large attributes “out of line” in a secondary table.

relhasindex bool

True if this is a table and it has (or recently had) any indexes

relisshared bool

True if this table is shared across all databases in the cluster. Only certain system catalogs (such as pg_database) are shared.

relpersistence char

p = permanent table, u = unlogged table, t = temporary table

relkind char

r = ordinary table, i = index, S = sequence, t = TOAST table, v = view, m = materialized view, c = composite type, f = foreign table, p = partitioned table, I = partitioned index

relnatts int2

Number of user columns in the relation (system columns not counted). There must be this many corresponding entries in pg_attribute. See also pg_attribute.attnum.

relchecks int2

relhasrules bool

relhastriggers bool

relhassubclass bool

True if table or index has (or once had) any inheritance children

relrowsecurity bool

relforcerowsecurity bool

relispopulated bool

True if relation is populated (this is true for all relations other than some materialized views)

relreplident char

Columns used to form “replica identity” for rows: d = default (primary key, if any), n = nothing, f = all columns, i = index with indisreplident set (same as nothing if the index used has been dropped)

relispartition bool

True if table or index is a partition

For new relations being written during a DDL operation that requires a table rewrite, this contains the OID of the original relation; otherwise 0. That state is only visible internally; this field should never contain anything other than 0 for a user-visible relation.

relfrozenxid xid

All transaction IDs before this one have been replaced with a permanent (“frozen”) transaction ID in this table. This is used to track whether the table needs to be vacuumed in order to prevent transaction ID wraparound or to allow pg_xact to be shrunk. Zero (InvalidTransactionId) if the relation is not a table.

relminmxid xid

All multixact IDs before this one have been replaced by a transaction ID in this table. This is used to track whether the table needs to be vacuumed in order to prevent multixact ID wraparound or to allow pg_multixact to be shrunk. Zero (InvalidMultiXactId) if the relation is not a table.

relacl aclitem[]

reloptions text[]

Access-method-specific options, as “keyword=value” strings

relpartbound pg_node_tree

If table is a partition (see relispartition), internal representation of the partition bound

Column Type

Description

oid oid

Row identifier

amname name

Name of the access method

amhandler regproc (references .oid)

OID of a handler function that is responsible for supplying information about the access method

amtype char

t = table (including materialized views), i = index.

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

conname

name

Constraint name (not necessarily unique!)

connamespace

oid

The OID of the namespace that contains this constraint

contype

char

c = check constraint, f = foreign key constraint, p = primary key constraint, u = unique constraint, t = constraint trigger, x = exclusion constraint

condeferrable

bool

Is the constraint deferrable?

condeferred

bool

Is the constraint deferred by default?

convalidated

bool

Has the constraint been validated? Currently, can only be false for foreign keys and CHECK constraints

conrelid

oid

The table this constraint is on; 0 if not a table constraint

contypid

oid

The domain this constraint is on; 0 if not a domain constraint

conindid

oid

The index supporting this constraint, if it's a unique, primary key, foreign key, or exclusion constraint; else 0

confrelid

oid

If a foreign key, the referenced table; else 0

confupdtype

char

Foreign key update action code: a = no action, r = restrict, c = cascade, n = set null, d = set default

confdeltype

char

Foreign key deletion action code: a = no action, r = restrict, c = cascade, n = set null, d = set default

confmatchtype

char

Foreign key match type: f = full, p = partial, s = simple

conislocal

bool

This constraint is defined locally for the relation. Note that a constraint can be locally defined and inherited simultaneously.

coninhcount

int4

The number of direct inheritance ancestors this constraint has. A constraint with a nonzero number of ancestors cannot be dropped nor renamed.

connoinherit

bool

This constraint is defined locally for the relation. It is a non-inheritable constraint.

conkey

int2[]

If a table constraint (including foreign keys, but not constraint triggers), list of the constrained columns

confkey

int2[]

If a foreign key, list of the referenced columns

conpfeqop

oid[]

If a foreign key, list of the equality operators for PK = FK comparisons

conppeqop

oid[]

If a foreign key, list of the equality operators for PK = PK comparisons

conffeqop

oid[]

If a foreign key, list of the equality operators for FK = FK comparisons

conexclop

oid[]

If an exclusion constraint, list of the per-column exclusion operators

conbin

pg_node_tree

If a check constraint, an internal representation of the expression

consrc

text

If a check constraint, a human-readable representation of the expression

attrelid

oid

The table this column belongs to

attname

name

The column name

atttypid

oid

The data type of this column

attstattarget

int4

attlen

int2

A copy of pg_type.typlen of this column's type

attnum

int2

The number of the column. Ordinary columns are numbered from 1 up. System columns, such as oid, have (arbitrary) negative numbers.

attndims

int4

Number of dimensions, if the column is an array type; otherwise 0. (Presently, the number of dimensions of an array is not enforced, so any nonzero value effectively means “it's an array”.)

attcacheoff

int4

Always -1 in storage, but when loaded into a row descriptor in memory this might be updated to cache the offset of the attribute within the row

atttypmod

int4

atttypmod records type-specific data supplied at table creation time (for example, the maximum length of a varchar column). It is passed to type-specific input functions and length coercion functions. The value will generally be -1 for types that do not need atttypmod.

attbyval

bool

A copy of pg_type.typbyval of this column's type

attstorage

char

Normally a copy of pg_type.typstorage of this column's type. For TOAST-able data types, this can be altered after column creation to control storage policy.

attalign

char

A copy of pg_type.typalign of this column's type

attnotnull

bool

This represents a not-null constraint.

atthasdef

bool

This column has a default value, in which case there will be a corresponding entry in the pg_attrdef catalog that actually defines the value.

attidentity

char

If a zero byte (''), then not an identity column. Otherwise, a = generated always, d = generated by default.

attisdropped

bool

This column has been dropped and is no longer valid. A dropped column is still physically present in the table, but is ignored by the parser and so cannot be accessed via SQL.

attislocal

bool

This column is defined locally in the relation. Note that a column can be locally defined and inherited simultaneously.

attinhcount

int4

The number of direct ancestors this column has. A column with a nonzero number of ancestors cannot be dropped nor renamed.

attcollation

oid

The defined collation of the column, or zero if the column is not of a collatable data type.

attacl

aclitem[]

Column-level access privileges, if any have been granted specifically on this column

attoptions

text[]

Attribute-level options, as “keyword=value” strings

attfdwoptions

text[]

Attribute-level foreign data wrapper options, as “keyword=value” strings

Column Type

Description

oid oid

Row identifier

castsource oid (references .oid)

OID of the source data type

casttarget oid (references .oid)

OID of the target data type

castfunc oid (references .oid)

The OID of the function to use to perform this cast. Zero is stored if the cast method doesn't require a function.

castcontext char

Indicates what contexts the cast can be invoked in. e means only as an explicit cast (using CAST or :: syntax). a means implicitly in assignment to a target column, as well as explicitly. i means implicitly in expressions, as well as the other cases.

castmethod char

Indicates how the cast is performed. f means that the function specified in the castfunc field is used. i means that the input/output functions are used. b means that the types are binary-coercible, thus no conversion is required.

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

collname

name

Collation name (unique per namespace and encoding)

collnamespace

oid

.oid

The OID of the namespace that contains this collation

collowner

oid

.oid

Owner of the collation

collprovider

char

Provider of the collation: d = database default, c = libc, i = icu

collencoding

int4

Encoding in which the collation is applicable, or -1 if it works for any encoding

collcollate

name

LC_COLLATE for this collation object

collctype

name

LC_CTYPE for this collation object

collversion

text

Provider-specific version of the collation. This is recorded when the collation is created and then checked when it is used, to detect changes in the collation definition that could lead to data corruption.

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

typname

name

Data type name

typnamespace

oid

The OID of the namespace that contains this type

typowner

oid

Owner of the type

typlen

int2

For a fixed-size type, typlen is the number of bytes in the internal representation of the type. But for a variable-length type, typlenis negative. -1 indicates a “varlena” type (one that has a length word), -2 indicates a null-terminated C string.

typbyval

bool

typbyval determines whether internal routines pass a value of this type by value or by reference. typbyval had better be false if typlen is not 1, 2, or 4 (or 8 on machines where Datum is 8 bytes). Variable-length types are always passed by reference. Note that typbyval can be false even if the length would allow pass-by-value.

typtype

char

typtype is b for a base type, c for a composite type (e.g., a table's row type), d for a domain, e for an enum type, p for a pseudo-type, or r for a range type. See also typrelid and typbasetype.

typcategory

char

typispreferred

bool

True if the type is a preferred cast target within its typcategory

typisdefined

bool

True if the type is defined, false if this is a placeholder entry for a not-yet-defined type. When typisdefined is false, nothing except the type name, namespace, and OID can be relied on.

typdelim

char

Character that separates two values of this type when parsing array input. Note that the delimiter is associated with the array element data type, not the array data type.

typrelid

oid

If this is a composite type (see typtype), then this column points to the pg_class entry that defines the corresponding table. (For a free-standing composite type, the pg_class entry doesn't really represent a table, but it is needed anyway for the type'spg_attribute entries to link to.) Zero for non-composite types.

typelem

oid

If typelem is not 0 then it identifies another row in pg_type. The current type can then be subscripted like an array yielding values of type typelem. A “true” array type is variable length (typlen = -1), but some fixed-length (typlen > 0) types also have nonzero typelem, for example name and point. If a fixed-length type has a typelem then its internal representation must be some number of values of the typelem data type with no other data. Variable-length array types have a header defined by the array subroutines.

typarray

oid

If typarray is not 0 then it identifies another row in pg_type, which is the “true” array type having this type as element

typinput

regproc

Input conversion function (text format)

typoutput

regproc

Output conversion function (text format)

typreceive

regproc

Input conversion function (binary format), or 0 if none

typsend

regproc

Output conversion function (binary format), or 0 if none

typmodin

regproc

Type modifier input function, or 0 if type does not support modifiers

typmodout

regproc

Type modifier output function, or 0 to use the standard format

typanalyze

regproc

Custom ANALYZE function, or 0 to use the standard function

typalign

char

typalign is the alignment required when storing a value of this type. It applies to storage on disk as well as most representations of the value inside PostgreSQL. When multiple values are stored consecutively, such as in the representation of a complete row on disk, padding is inserted before a datum of this type so that it begins on the specified boundary. The alignment reference is the beginning of the first datum in the sequence.Possible values are:c = char alignment, i.e., no alignment needed.s = short alignment (2 bytes on most machines).i = int alignment (4 bytes on most machines).d = double alignment (8 bytes on many machines, but by no means all).NoteFor types used in system tables, it is critical that the size and alignment defined in pg_typeagree with the way that the compiler will lay out the column in a structure representing a table row.

typstorage

char

typstorage tells for varlena types (those with typlen = -1) if the type is prepared for toasting and what the default strategy for attributes of this type should be. Possible values arep: Value must always be stored plain.e: Value can be stored in a “secondary” relation (if relation has one, see pg_class.reltoastrelid).m: Value can be stored compressed inline.x: Value can be stored compressed inline or stored in “secondary” storage.Note that m columns can also be moved out to secondary storage, but only as a last resort (e and x columns are moved first).

typnotnull

bool

typnotnull represents a not-null constraint on a type. Used for domains only.

typbasetype

oid

If this is a domain (see typtype), then typbasetype identifies the type that this one is based on. Zero if this type is not a domain.

typtypmod

int4

Domains use typtypmod to record the typmod to be applied to their base type (-1 if base type does not use a typmod). -1 if this type is not a domain.

typndims

int4

typndims is the number of array dimensions for a domain over an array (that is, typbasetype is an array type). Zero for types other than domains over array types.

typcollation

oid

typcollation specifies the collation of the type. If the type does not support collations, this will be zero. A base type that supports collations will have DEFAULT_COLLATION_OID here. A domain over a collatable type can have some other collation OID, if one was specified for the domain.

typdefaultbin

pg_node_tree

If typdefaultbin is not null, it is the nodeToString() representation of a default expression for the type. This is only used for domains.

typdefault

text

typdefault is null if the type has no associated default value. If typdefaultbin is not null, typdefault must contain a human-readable version of the default expression represented by typdefaultbin. If typdefaultbin is null and typdefault is not, then typdefault is the external representation of the type's default value, which can be fed to the type's input converter to produce a constant.

typacl

aclitem[]

A

Array types

B

Boolean types

C

Composite types

D

Date/time types

E

Enum types

G

Geometric types

I

Network address types

N

Numeric types

P

Pseudo-types

R

Range types

S

String types

T

Timespan types

U

User-defined types

V

Bit-string types

X

unknown type

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

proname

name

Name of the function

pronamespace

oid

The OID of the namespace that contains this function

proowner

oid

Owner of the function

prolang

oid

Implementation language or call interface of this function

procost

float4

prorows

float4

Estimated number of result rows (zero if not proretset)

provariadic

oid

Data type of the variadic array parameter's elements, or zero if the function does not have a variadic parameter

protransform

regproc

prokind

char

f for a normal function, p for a procedure, a for an aggregate function, or w for a window function

prosecdef

bool

Function is a security definer (i.e., a “setuid” function)

proleakproof

bool

The function has no side effects. No information about the arguments is conveyed except via the return value. Any function that might throw an error depending on the values of its arguments is not leak-proof.

proisstrict

bool

Function returns null if any call argument is null. In that case the function won't actually be called at all. Functions that are not “strict” must be prepared to handle null inputs.

proretset

bool

Function returns a set (i.e., multiple values of the specified data type)

provolatile

char

provolatile tells whether the function's result depends only on its input arguments, or is affected by outside factors. It is i for “immutable” functions, which always deliver the same result for the same inputs. It is s for “stable” functions, whose results (for fixed inputs) do not change within a scan. It is v for “volatile” functions, whose results might change at any time. (Use v also for functions with side-effects, so that calls to them cannot get optimized away.)

proparallel

char

proparallel tells whether the function can be safely run in parallel mode. It is s for functions which are safe to run in parallel mode without restriction. It is r for functions which can be run in parallel mode, but their execution is restricted to the parallel group leader; parallel worker processes cannot invoke these functions. It is u for functions which are unsafe in parallel mode; the presence of such a function forces a serial execution plan.

pronargs

int2

Number of input arguments

pronargdefaults

int2

Number of arguments that have defaults

prorettype

oid

Data type of the return value

proargtypes

oidvector

An array with the data types of the function arguments. This includes only input arguments (including INOUT and VARIADIC arguments), and thus represents the call signature of the function.

proallargtypes

oid[]

An array with the data types of the function arguments. This includes all arguments (including OUT and INOUT arguments); however, if all the arguments are IN arguments, this field will be null. Note that subscripting is 1-based, whereas for historical reasons proargtypes is subscripted from 0.

proargmodes

char[]

An array with the modes of the function arguments, encoded as i for IN arguments, o for OUT arguments, b for INOUT arguments, v for VARIADIC arguments, t for TABLE arguments. If all the arguments are IN arguments, this field will be null. Note that subscripts correspond to positions of proallargtypes not proargtypes.

proargnames

text[]

An array with the names of the function arguments. Arguments without a name are set to empty strings in the array. If none of the arguments have a name, this field will be null. Note that subscripts correspond to positions of proallargtypes not proargtypes.

proargdefaults

pg_node_tree

Expression trees (in nodeToString() representation) for default values. This is a list with pronargdefaults elements, corresponding to the last N input arguments (i.e., the last N proargtypes positions). If none of the arguments have defaults, this field will be null.

protrftypes

oid[]

Data type OIDs for which to apply transforms.

prosrc

text

This tells the function handler how to invoke the function. It might be the actual source code of the function for interpreted languages, a link symbol, a file name, or just about anything else, depending on the implementation language/call convention.

probin

text

Additional information about how to invoke the function. Again, the interpretation is language-specific.

proconfig

text[]

Function's local settings for run-time configuration variables

proacl

aclitem[]

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

tgrelid

oid

The table this trigger is on

tgname

name

Trigger name (must be unique among triggers of same table)

tgfoid

oid

The function to be called

tgtype

int2

Bit mask identifying trigger firing conditions

tgenabled

char

tgisinternal

bool

True if trigger is internally generated (usually, to enforce the constraint identified by tgconstraint)

tgconstrrelid

oid

The table referenced by a referential integrity constraint

tgconstrindid

oid

The index supporting a unique, primary key, referential integrity, or exclusion constraint

tgconstraint

oid

The pg_constraint entry associated with the trigger, if any

tgdeferrable

bool

True if constraint trigger is deferrable

tginitdeferred

bool

True if constraint trigger is initially deferred

tgnargs

int2

Number of argument strings passed to trigger function

tgattr

int2vector

Column numbers, if trigger is column-specific; otherwise an empty array

tgargs

bytea

Argument strings to pass to trigger, each NULL-terminated

tgqual

pg_node_tree

Expression tree (in nodeToString() representation) for the trigger's WHEN condition, or null if none

tgoldtable

name

REFERENCING clause name for OLD TABLE, or null if none

tgnewtable

name

REFERENCING clause name for NEW TABLE, or null if none

oid

oid

資料列指標ID

extname

name

延伸功能名稱

extowner

oid

``.oid

延伸功能的擁有者

extnamespace

oid

``.oid

延伸功能之中所導出物件的綱要名稱

extrelocatable

bool

如果延伸功能可以接受重新定位到另一個綱要之中，則為 True

extversion

text

延伸功能的版本名稱

extconfig

oid[]

``.oid

延伸功能組態資料表的 regclass OID 陣列，如果沒有，則為 NULL

extcondition

text[]

延伸功能組態資料表的 WHERE 子句過濾條件陣列，如果沒有，則為 NULL

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

opcmethod

oid

.oid

Index access method operator class is for

opcname

name

Name of this operator class

opcnamespace

oid

.oid

Namespace of this operator class

opcowner

oid

.oid

Owner of the operator class

opcfamily

oid

.oid

Operator family containing the operator class

opcintype

oid

.oid

Data type that the operator class indexes

opcdefault

bool

True if this operator class is the default for opcintype

opckeytype

oid

.oid

Type of data stored in index, or zero if same as opcintype

Column Type

Description

oid oid

Row identifier

stxrelid oid (references .oid)

Table containing the columns described by this object

stxname name

Name of the statistics object

stxnamespace oid (references .oid)

The OID of the namespace that contains this statistics object

stxowner oid (references .oid)

Owner of the statistics object

stxstattarget int4

stxstattarget controls the level of detail of statistics accumulated for this statistics object by . A zero value indicates that no statistics should be collected. A negative value says to use the maximum of the statistics targets of the referenced columns, if set, or the system default statistics target. Positive values of stxstattarget determine the target number of “most common values” to collect.

stxkeys int2vector (references .attnum)

An array of attribute numbers, indicating which table columns are covered by this statistics object; for example a value of 1 3 would mean that the first and the third table columns are covered

stxkind char[]

An array containing codes for the enabled statistic kinds; valid values are: d for n-distinct statistics, f for functional dependency statistics, and m for most common values (MCV) list statistics

Column Type

Description

starelid oid (references .oid)

The table or index that the described column belongs to

staattnum int2 (references .attnum)

The number of the described column

stainherit bool

If true, the stats include inheritance child columns, not just the values in the specified relation

stanullfrac float4

The fraction of the column's entries that are null

stawidth int4

The average stored width, in bytes, of nonnull entries

stadistinct float4

The number of distinct nonnull data values in the column. A value greater than zero is the actual number of distinct values. A value less than zero is the negative of a multiplier for the number of rows in the table; for example, a column in which about 80% of the values are nonnull and each nonnull value appears about twice on average could be represented by stadistinct = -0.4. A zero value means the number of distinct values is unknown.

stakindN int2

A code number indicating the kind of statistics stored in the Nth “slot” of the pg_statistic row.

staopN oid (references .oid)

An operator used to derive the statistics stored in the Nth “slot”. For example, a histogram slot would show the < operator that defines the sort order of the data.

stacollN oid (references .oid)

The collation used to derive the statistics stored in the Nth “slot”. For example, a histogram slot for a collatable column would show the collation that defines the sort order of the data. Zero for noncollatable data.

stanumbersN float4[]

Numerical statistics of the appropriate kind for the Nth “slot”, or null if the slot kind does not involve numerical values

stavaluesN anyarray

Column data values of the appropriate kind for the Nth “slot”, or null if the slot kind does not store any data values. Each array's element values are actually of the specific column's data type, or a related type such as an array's element type, so there is no way to define these columns' type more specifically than anyarray.

Column Type

Description

oid oid

Row identifier

subdbid oid (references .oid)

OID of the database which the subscription resides in

subname name

Name of the subscription

subowner oid (references .oid)

Owner of the subscription

subenabled bool

If true, the subscription is enabled and should be replicating.

subconninfo text

Connection string to the upstream database

subslotname name

Name of the replication slot in the upstream database (also used for the local replication origin name); null represents NONE

subsynccommit text

Contains the value of the synchronous_commit setting for the subscription workers.

subpublications text[]

Array of subscribed publication names. These reference the publications on the publisher server. For more on publications see .

Column Type

Description

srsubid oid (references .oid)

Reference to subscription

srrelid oid (references .oid)

Reference to relation

srsubstate char

State code: i = initialize, d = data is being copied, s = synchronized, r = ready (normal replication)

srsublsn pg_lsn

Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

rulename

name

Rule name

ev_class

oid

.oid

The table this rule is for

ev_type

char

Event type that the rule is for: 1 = SELECT, 2 = UPDATE, 3 = INSERT, 4 = DELETE

ev_enabled

char

Controls in which modes the rule fires. O = rule fires in “origin” and “local” modes, D = rule is disabled, R = rule fires in “replica” mode, A = rule fires always.

is_instead

bool

True if the rule is an INSTEAD rule

ev_qual

pg_node_tree

Expression tree (in the form of a nodeToString() representation) for the rule's qualifying condition

ev_action

pg_node_tree

Query tree (in the form of a nodeToString() representation) for the rule's action

Column Type

Description

oid oid

Row identifier

spcname name

Tablespace name

spcowner oid (references .oid)

Owner of the tablespace, usually the user who created it

spcacl aclitem[]

Access privileges; see for details

spcoptions text[]

Tablespace-level options, as “keyword=value” strings