Column Type

Description

oid oid

Row identifier

rolname name

Role name

rolsuper bool

Role has superuser privileges

rolinherit bool

Role automatically inherits privileges of roles it is a member of

rolcreaterole bool

Role can create more roles

rolcreatedb bool

Role can create databases

rolcanlogin bool

Role can log in. That is, this role can be given as the initial session authorization identifier

rolreplication bool

Role is a replication role. A replication role can initiate replication connections and create and drop replication slots.

rolbypassrls bool

Role bypasses every row level security policy, see Section 5.8 for more information.

rolconnlimit int4

For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit.

rolpassword text

Password (possibly encrypted); null if none. The format depends on the form of encryption used.

rolvaliduntil timestamptz

Password expiry time (only used for password authentication); null if no expiration

attrelid

oid

pg_class.oid

The table this column belongs to

attname

name

The column name

atttypid

oid

pg_type.oid

The data type of this column

attstattarget

int4

attstattarget controls the level of detail of statistics accumulated for this column by ANALYZE. A zero value indicates that no statistics should be collected. A negative value says to use the system default statistics target. The exact meaning of positive values is data type-dependent. For scalar data types, attstattarget is both the target number of “most common values” to collect, and the target number of histogram bins to create.

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

pg_collation.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

roleid

oid

``pg_authid.oid

具有成員的角色 ID

member

oid

pg_authid.oid

作為 roleid 成員的角色 ID

grantor

oid

``pg_authid.oid

授予此成員資格的角色 ID

admin_option

bool

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

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

conname

name

Constraint name (not necessarily unique!)

connamespace

oid

pg_namespace.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

pg_class.oid

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

contypid

oid

pg_type.oid

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

conindid

oid

pg_class.oid

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

confrelid

oid

pg_class.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[]

pg_attribute.attnum

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

confkey

int2[]

pg_attribute.attnum

If a foreign key, list of the referenced columns

conpfeqop

oid[]

pg_operator.oid

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

conppeqop

oid[]

pg_operator.oid

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

conffeqop

oid[]

pg_operator.oid

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

conexclop

oid[]

pg_operator.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

Column Type

Description

oid oid

Row identifier

evtname name

Trigger name (must be unique)

evtevent name

Identifies the event for which this trigger fires

evtowner oid (references pg_authid.oid)

Owner of the event trigger

evtfoid oid (references pg_proc.oid)

The function to be called

evtenabled char

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

evttags text[]

Command tags for which this trigger will fire. If NULL, the firing of this trigger is not restricted on the basis of the command tag.

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

collname

name

Collation name (unique per namespace and encoding)

collnamespace

oid

pg_namespace.oid

The OID of the namespace that contains this collation

collowner

oid

pg_authid.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

資料列識別指標（隱藏屬性；必須明確選擇）

lanname

name

語言名稱

lanowner

oid

``pg_authid.oid

語言的所有者

lanispl

bool

對於內部語言（例如 SQL）而言這是 false 的，對於使用者定義的語言則是 true。目前，pg_dump 仍然使用它來決定需要轉存哪些語言，但將來可能會被不同的機制所取代。

lanpltrusted

bool

如果這是一種受信任的語言，則為 True，這意味著它被認為不會授予對正常 SQL 執行環境之外任何內容的存取權限。只有超級使用者才能以不受信任的語言建立函數。

lanplcallfoid

oid

``pg_proc.oid

對於非內部語言，這引用了語言處理程序，它是一個特殊的函數，負責執行使用特定語言所編寫的所有函數。

laninline

oid

``pg_proc.oid

這引用了一個負責執行 “inline” 匿名程式區塊（DO 區塊）的函數。如果不支援 inline 區塊，則為零。

lanvalidator

oid

``pg_proc.oid

這引用了一個語言驗證器函數，該函數負責在建立新函數時檢查它們的語法和有效性。如果未提供驗證器，則為零。

lanacl

aclitem[]

存取權限；有關詳細訊息，請參閱 GRANT 和 REVOKE

Column Type

Description

oid oid

Row identifier

nspname name

Name of the namespace

nspowner oid (references pg_authid.oid)

Owner of the namespace

nspacl aclitem[]

存取權限； 詳見 5.7 節

Column Type

Description

oid oid

Row identifier

amname name

Name of the access method

amhandler regproc (references pg_proc.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.

Column Type

Description

oid oid

Row identifier

stxrelid oid (references pg_class.oid)

Table containing the columns described by this object

stxname name

Name of the statistics object

stxnamespace oid (references pg_namespace.oid)

The OID of the namespace that contains this statistics object

stxowner oid (references pg_authid.oid)

Owner of the statistics object

stxstattarget int4

stxstattarget controls the level of detail of statistics accumulated for this statistics object by ANALYZE. 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 pg_attribute.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

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

opcmethod

oid

pg_am.oid

Index access method operator class is for

opcname

name

Name of this operator class

opcnamespace

oid

pg_namespace.oid

Namespace of this operator class

opcowner

oid

pg_authid.oid

Owner of the operator class

opcfamily

oid

pg_opfamily.oid

Operator family containing the operator class

opcintype

oid

pg_type.oid

Data type that the operator class indexes

opcdefault

bool

True if this operator class is the default for opcintype

opckeytype

oid

pg_type.oid

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

polname

name

The name of the policy

polrelid

oid

pg_class.oid

The table to which the policy applies

polcmd

char

The command type to which the policy is applied: r for SELECT, a for INSERT, w for UPDATE, d for DELETE, or * for all

polpermissive

boolean

Is the policy permissive or restrictive?

polroles

oid[]

pg_authid.oid

The roles to which the policy is applied

polqual

pg_node_tree

The expression tree to be added to the security barrier qualifications for queries that use the table

polwithcheck

pg_node_tree

The expression tree to be added to the WITH CHECK qualifications for queries that attempt to add rows to the table

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

typname

name

Data type name

typnamespace

oid

pg_namespace.oid

The OID of the namespace that contains this type

typowner

oid

pg_authid.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

typcategory is an arbitrary classification of data types that is used by the parser to determine which implicit casts should be “preferred”. See Table 51.63.

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

pg_class.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

pg_type.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

pg_type.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

pg_proc.oid

Input conversion function (text format)

typoutput

regproc

pg_proc.oid

Output conversion function (text format)

typreceive

regproc

pg_proc.oid

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

typsend

regproc

pg_proc.oid

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

typmodin

regproc

pg_proc.oid

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

typmodout

regproc

pg_proc.oid

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

typanalyze

regproc

pg_proc.oid

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

pg_type.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

pg_collation.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[]

Access privileges; see GRANT and REVOKE for details

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

Column Type

Description

schemaname name (references pg_namespace.nspname)

Name of schema containing table and index

tablename name (references pg_class.relname)

Name of table the index is for

indexname name (references pg_class.relname)

Name of index

tablespace name (references pg_tablespace.spcname)

Name of tablespace containing index (null if default for database)

indexdef text

Index definition (a reconstructed CREATE INDEX command)

Column Type

Description

oid oid

Row identifier

subdbid oid (references pg_database.oid)

OID of the database which the subscription resides in

subname name

Name of the subscription

subowner oid (references pg_authid.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 Section 30.1.

Column Type

Description

locktype text

Type of the lockable object: relation, extend, frozenid, page, tuple, transactionid, virtualxid, spectoken, object, userlock, or advisory. (See also Table 27.11.)

database oid (references pg_database.oid)

OID of the database in which the lock target exists, or zero if the target is a shared object, or null if the target is a transaction ID

relation oid (references pg_class.oid)

OID of the relation targeted by the lock, or null if the target is not a relation or part of a relation

page int4

Page number targeted by the lock within the relation, or null if the target is not a relation page or tuple

tuple int2

Tuple number targeted by the lock within the page, or null if the target is not a tuple

virtualxid text

Virtual ID of the transaction targeted by the lock, or null if the target is not a virtual transaction ID

transactionid xid

ID of the transaction targeted by the lock, or null if the target is not a transaction ID

classid oid (references pg_class.oid)

OID of the system catalog containing the lock target, or null if the target is not a general database object

objid oid (references any OID column)

OID of the lock target within its system catalog, or null if the target is not a general database object

objsubid int2

Column number targeted by the lock (the classid and objid refer to the table itself), or zero if the target is some other general database object, or null if the target is not a general database object

virtualtransaction text

Virtual ID of the transaction that is holding or awaiting this lock

pid int4

Process ID of the server process holding or awaiting this lock, or null if the lock is held by a prepared transaction

mode text

Name of the lock mode held or desired by this process (see Section 13.3.1 and Section 13.2.3)

granted bool

True if lock is held, false if lock is awaited

fastpath bool

True if lock was taken via fast path, false if taken via main lock table

name

name

延伸功能名稱

version

text

版本名稱

installed

bool

如果目前已安裝此延伸功能的此版本，則為 True

superuser

bool

如果僅允許超級使用者安裝此延伸功能，則為 True

relocatable

bool

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

schema

name

延伸功能必須安裝到的綱要名稱，如果可部分或完全重新定位，則為 NULL

requires

name[]

必須預先安裝的延伸功能名稱，如果沒有則為 NULL

comment

text

延伸功能控制檔案中的註解文字內容

Column Type

Description

line_number int4

Line number of this rule in pg_hba.conf

type text

Type of connection

database text[]

List of database name(s) to which this rule applies

user_name text[]

List of user and group name(s) to which this rule applies

address text

Host name or IP address, or one of all, samehost, or samenet, or null for local connections

netmask text

IP address mask, or null if not applicable

auth_method text

Authentication method

options text[]

Options specified for authentication method, if any

error text

If not null, an error message indicating why this line could not be processed

oid

oid

資料列識別指標（隱藏屬性；必須明確選擇）

datname

name

資料庫名稱

datdba

oid

pg_authid.oid

資料庫的擁有者，通常是建立它的使用者

encoding

int4

此資料庫的字元編碼（pg_encoding_to_char（）可將此數字轉換為編碼名稱）

datcollate

name

這個資料庫的 LC_COLLATE

datctype

name

這個資料庫的 LC_CTYPE

datistemplate

bool

如果為 true，則該資料庫可以由具有 CREATEDB 權限的任何使用者複製；如果為 false，則只有超級使用者或資料庫的擁有者才能複製它。

datallowconn

bool

如果為 false，則沒有人可以連線到該資料庫。這用於保護 template0 資料庫免遭更改。

datconnlimit

int4

設定可以對此資料庫執行的最大同時連線數。-1 意味著沒有限制。

datlastsysoid

oid

資料庫中的最後一個系統 OID；特別適用於 pg_dump

datfrozenxid

xid

在這個事務 ID 之前在此資料庫中的所有事務 ID，已被替換為永久（「 frozen」）。這用於追踪是否需要清理資料庫以防止事務 ID 重覆或允許縮減 pg_xact。它是每個資料表 pg_class.relfrozenxid 的最小值。

datminmxid

xid

此資料庫中的所有 multixact ID 已被替換為該資料庫中的事務 ID。這用於追踪資料庫是否需要清理，以防止 multixact ID 重覆或允許縮減 pg_multixact。它是每個資料表 pg_class.relminmxid 的最小值。

dattablespace

oid

pg_tablespace.oid

資料庫預設的資料表空間。在此資料庫中，pg_class.reltablespace 為零的所有資料表都將儲存在此資料表空間中；特別是所有非共享系統目錄都將在那裡。

datacl

aclitem[]

存取權限；詳情請參閱 GRANT 和 REVOKE

Column Type

Description

transaction xid

Numeric transaction identifier of the prepared transaction

gid text

Global transaction identifier that was assigned to the transaction

prepared timestamptz

Time at which the transaction was prepared for commit

owner name (references pg_authid.rolname)

Name of the user that executed the transaction

database name (references pg_database.datname)

Name of the database in which the transaction was executed

local_id

Oid

pg_replication_origin.roident

internal node identifier

external_id

text

pg_replication_origin.roname

external node identifier

remote_lsn

pg_lsn

The origin node's LSN up to which data has been replicated.

local_lsn

pg_lsn

This node's LSN at which remote_lsn has been replicated. Used to flush commit records before persisting data to disk when using asynchronous commits.

name

name

Extension name

default_version

text

預設版本的名稱；如果未指定，則為 NULL

installed_version

text

目前安裝的延伸功能版本，如果未安裝，則為 NULL

comment

text

延伸功能的控制檔案中的註解文字內容