Introduction

Built from the following configuration files:

https://github.com/greenplum-db/gpdb/tree/master/gpMgmt/bin/gppylib/data

See the code:

https://github.com/stephendotcarter/greenplum-syscat-ref

Summary

Greenplum Version:	5.0
Catalog Version:	201510270

Has OIDs	Shared	Persistent	Master Only	Segment Local
pg_am pg_attrdef pg_attribute pg_authid pg_cast pg_class pg_compression pg_constraint pg_conversion pg_database pg_filespace pg_foreign_data_wrapper pg_foreign_server pg_language pg_namespace pg_opclass pg_operator pg_partition pg_partition_rule pg_proc pg_resourcetype pg_resqueue pg_resqueuecapability pg_rewrite pg_tablespace pg_trigger pg_type pg_user_mapping	gp_configuration gp_configuration_history gp_db_interfaces gp_fault_strategy gp_id gp_interfaces gp_persistent_database_node gp_persistent_filespace_node gp_persistent_relation_node gp_persistent_tablespace_node gp_san_configuration gp_segment_configuration gp_verification_history gp_version_at_initdb pg_auth_members pg_auth_time_constraint pg_authid pg_database pg_filespace pg_filespace_entry pg_pltemplate pg_resourcetype pg_resqueue pg_resqueuecapability pg_shdepend pg_shdescription pg_stat_last_shoperation pg_tablespace	gp_global_sequence gp_persistent_database_node gp_persistent_filespace_node gp_persistent_relation_node gp_persistent_tablespace_node gp_relation_node	gp_configuration gp_configuration_history gp_db_interfaces gp_distribution_policy gp_fault_strategy gp_interfaces gp_san_configuration gp_segment_configuration gp_verification_history pg_description pg_filespace_entry pg_listener pg_partition pg_partition_rule pg_shdescription pg_stat_last_operation pg_stat_last_shoperation	gp_fastsequence gp_id pg_depend pg_shdepend pg_statistic

Relations

gp_configuration PNG SVG

Column	Type	Foreign Key	Reference Keys
content	smallint
definedprimary	boolean
dbid	smallint
isprimary	boolean
valid	boolean
hostname	name
port	integer
datadir	text

Indexes	gp_configuration_content_definedprimary_index_id UNIQUE (content, definedprimary) gp_configuration_dbid_index_id UNIQUE (dbid)
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

gp_configuration_history PNG SVG

Column	Type	Foreign Key	Reference Keys
time	timestamp_with_time_zone
dbid	smallint
desc	text

Indexes
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

gp_db_interfaces PNG SVG

Column	Type	Foreign Key	Reference Keys
dbid	smallint
interfaceid	smallint
priority	smallint

Indexes	gp_db_interfaces_dbid_index_id (dbid)
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

gp_distribution_policy PNG SVG

Column	Type	Foreign Key	Reference Keys
localoid	oid	pg_class.oid
attrnums	smallint[]

Indexes	gp_policy_local_oid_index_id UNIQUE (localoid)
Has OIDs	No
Content	MASTER_ONLY
Shared	No

gp_fastsequence PNG SVG

Column	Type	Foreign Key
objid	oid	pg_class.oid
objmod	bigint
last_sequence	bigint

Indexes	fast_sequence_objid_objmod_index_id UNIQUE (objid, objmod)
Has OIDs	No
Content	SEGMENT_LOCAL
Shared	No

gp_fault_strategy PNG SVG

Column	Type	Foreign Key	Reference Keys
fault_strategy	quoted_char

Indexes
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

gp_global_sequence PNG SVG

Column	Type	Foreign Key	Reference Keys
sequence_num	bigint

Indexes
Has OIDs	No
Content	PERSISTENT
Shared	No

gp_id PNG SVG

Column	Type	Foreign Key	Reference Keys
gpname	name
numsegments	smallint
dbid	smallint
content	smallint

Indexes
Has OIDs	No
Content	SEGMENT_LOCAL
Shared	Yes

gp_interfaces PNG SVG

Column	Type	Foreign Key	Reference Keys
interfaceid	smallint
address	name
status	smallint

Indexes	gp_interfaces_interfaceid_index_id UNIQUE (interfaceid)
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

gp_persistent_database_node PNG SVG

Column	Type	Foreign Key	Reference Keys
tablespace_oid	oid
database_oid	oid
persistent_state	smallint
create_mirror_data_loss_tracking_session_num	bigint
mirror_existence_state	smallint
reserved	integer
parent_xid	integer
persistent_serial_num	bigint
previous_free_tid	tid

Indexes
Has OIDs	No
Content	PERSISTENT
Shared	Yes

gp_persistent_filespace_node PNG SVG

Column	Type	Foreign Key	Reference Keys
filespace_oid	oid
db_id_1	smallint
location_1	text
db_id_2	smallint
location_2	text
persistent_state	smallint
create_mirror_data_loss_tracking_session_num	bigint
mirror_existence_state	smallint
reserved	integer
parent_xid	integer
persistent_serial_num	bigint
previous_free_tid	tid

Indexes
Has OIDs	No
Content	PERSISTENT
Shared	Yes

gp_persistent_relation_node PNG SVG

Column	Type	Foreign Key	Reference Keys
tablespace_oid	oid
database_oid	oid
relfilenode_oid	oid
segment_file_num	integer
relation_storage_manager	smallint
persistent_state	smallint
create_mirror_data_loss_tracking_session_num	bigint
mirror_existence_state	smallint
mirror_data_synchronization_state	smallint
mirror_bufpool_marked_for_scan_incremental_resync	boolean
mirror_bufpool_resync_changed_page_count	bigint
mirror_bufpool_resync_ckpt_loc	gpxlogloc
mirror_bufpool_resync_ckpt_block_num	integer
mirror_append_only_loss_eof	bigint
mirror_append_only_new_eof	bigint
relation_bufpool_kind	integer
parent_xid	integer
persistent_serial_num	bigint
previous_free_tid	tid

Indexes
Has OIDs	No
Content	PERSISTENT
Shared	Yes

gp_persistent_tablespace_node PNG SVG

Column	Type	Foreign Key	Reference Keys
filespace_oid	oid
tablespace_oid	oid
persistent_state	smallint
create_mirror_data_loss_tracking_session_num	bigint
mirror_existence_state	smallint
reserved	integer
parent_xid	integer
persistent_serial_num	bigint
previous_free_tid	tid

Indexes
Has OIDs	No
Content	PERSISTENT
Shared	Yes

gp_relation_node PNG SVG

Column	Type	Foreign Key
relfilenode_oid	oid	pg_class.oid
segment_file_num	integer
create_mirror_data_loss_tracking_session_num	bigint
persistent_tid	tid
persistent_serial_num	bigint

Indexes
Has OIDs	No
Content	PERSISTENT
Shared	No

gp_san_configuration PNG SVG

Column	Type	Foreign Key	Reference Keys
mountid	smallint
active_host	quoted_char
san_type	quoted_char
primary_host	text
primary_mountpoint	text
primary_device	text
mirror_host	text
mirror_mountpoint	text
mirror_device	text

Indexes	gp_san_config_mountid_index_id UNIQUE (mountid)
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

gp_segment_configuration PNG SVG

Column	Type	Foreign Key	Reference Keys
dbid	smallint
content	smallint
role	quoted_char
preferred_role	quoted_char
mode	quoted_char
status	quoted_char
port	integer
hostname	text
address	text
replication_port	integer
san_mounts	int2vector

Indexes	gp_segment_config_content_preferred_role_index_id UNIQUE (content, preferred_role) gp_segment_config_dbid_index_id UNIQUE (dbid)
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

gp_verification_history PNG SVG

Column	Type	Foreign Key	Reference Keys
vertoken	name
vertype	smallint
vercontent	smallint
verstarttime	timestamp_with_time_zone
verstate	smallint
verdone	boolean
verendtime	timestamp_with_time_zone
vermismatch	boolean

Indexes	gp_verification_history_vertoken_index_id UNIQUE (vertoken)
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

gp_version_at_initdb PNG SVG

Column	Type	Foreign Key	Reference Keys
schemaversion	smallint
productversion	text

Indexes
Has OIDs	No
Content
Shared	Yes

pg_aggregate PNG SVG

Column	Type	Foreign Key
aggfnoid	regproc	pg_proc.oid
aggtransfn	regproc	pg_proc.oid
agginvtransfn	regproc	pg_proc.oid
aggprelimfn	regproc	pg_proc.oid
agginvprelimfn	regproc	pg_proc.oid
aggfinalfn	regproc	pg_proc.oid
aggsortop	oid	pg_operator.oid
aggtranstype	oid	pg_type.oid
agginitval	text
aggordered	bool

Indexes	aggregate_aggfnoid_index_id UNIQUE (aggfnoid)
Has OIDs	No
Content
Shared	No

pg_am PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_class.relam
amname	name
amstrategies	smallint
amsupport	smallint
amorderstrategy	smallint
amcanunique	boolean
amcanmulticol	boolean
amoptionalkey	boolean
amindexnulls	boolean
amstorage	boolean
amclusterable	boolean
amcanshrink	boolean
aminsert	regproc	pg_proc.oid
ambeginscan	regproc	pg_proc.oid
amgettuple	regproc	pg_proc.oid
amgetmulti	regproc	pg_proc.oid
amrescan	regproc	pg_proc.oid
amendscan	regproc	pg_proc.oid
ammarkpos	regproc	pg_proc.oid
amrestrpos	regproc	pg_proc.oid
ambuild	regproc	pg_proc.oid
ambulkdelete	regproc	pg_proc.oid
amvacuumcleanup	regproc	pg_proc.oid
amcostestimate	regproc	pg_proc.oid
amoptions	regproc	pg_proc.oid

Indexes	am_name_index_id UNIQUE (amname) am_oid_index_id UNIQUE (oid)
Has OIDs	Yes
Content
Shared	No

pg_amop PNG SVG

Column	Type	Foreign Key
amopclaid	oid	pg_opclass.oid
amopsubtype	oid	pg_type.oid
amopstrategy	smallint
amopreqcheck	boolean
amopopr	oid	pg_operator.oid

Indexes	access_method_strategy_index_id UNIQUE (amopclaid, amopsubtype, amopstrategy) access_method_operator_index_id UNIQUE (amopopr, amopclaid)
Has OIDs	No
Content
Shared	No

pg_amproc PNG SVG

Column	Type	Foreign Key
amopclaid	oid	pg_opclass.oid
amprocsubtype	oid	pg_type.oid
amprocnum	smallint
amproc	regproc	pg_proc.oid

Indexes	access_method_procedure_index_id UNIQUE (amopclaid, amprocsubtype, amprocnum)
Has OIDs	No
Content
Shared	No

pg_appendonly PNG SVG

Column	Type	Foreign Key
relid	oid	pg_class.oid
blocksize	integer
safefswritesize	integer
compresslevel	smallint
majorversion	smallint
minorversion	smallint
checksum	boolean
compresstype	text
columnstore	boolean
segrelid	oid
segidxid	oid
blkdirrelid	oid
blkdiridxid	oid
version	integer
visimaprelid	oid
visimapidxid	oid

Indexes	append_only_relid_index_id UNIQUE (relid)
Has OIDs	No
Content
Shared	No

pg_appendonly_alter_column PNG SVG

Column	Type	Foreign Key
relid	oid	pg_class.oid
changenum	integer
segfilenums	integer[]
highwaterrownums	bytea

Indexes	append_only_alter_column_relid_index_id UNIQUE (relid, changenum)
Has OIDs	No
Content
Shared	No

pg_attrdef PNG SVG

Column	Type	Foreign Key
oid	oid
adrelid	oid	pg_attribute.attrelid
adnum	smallint
adbin	text
adsrc	text

Indexes	attr_default_index_id UNIQUE (adrelid, adnum) attr_default_oid_index_id UNIQUE (oid)
Has OIDs	Yes
Content
Shared	No

pg_attribute PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid
attrelid	oid	pg_class.oid	pg_attrdef.adrelid pg_attribute_encoding.attrelid pg_rewrite.ev_class pg_statistic.starelid
attname	name
atttypid	oid	pg_type.oid
attstattarget	integer
attlen	smallint
attnum	smallint
attndims	integer
attcacheoff	integer
atttypmod	integer
attbyval	boolean
attstorage	quoted_char
attalign	quoted_char
attnotnull	boolean
atthasdef	boolean
attisdropped	boolean
attislocal	boolean
attinhcount	integer

Indexes	attribute_relid_name_index_id UNIQUE (attrelid, attname) attribute_relid_num_index_id UNIQUE (attrelid, attnum)
Has OIDs	Yes
Content
Shared	No

pg_attribute_encoding PNG SVG

Column	Type	Foreign Key
attrelid	oid	pg_attribute.attrelid
attnum	smallint
attoptions	text[]

Indexes	attribute_encoding_attrelid_index_id (attrelid) attribute_encoding_attrelid_attnum_index_id UNIQUE (attrelid, attnum)
Has OIDs	No
Content
Shared	No

pg_auth_members PNG SVG

Column	Type	Foreign Key
roleid	oid	pg_authid.oid
member	oid	pg_authid.oid
grantor	oid
admin_option	boolean

Indexes	auth_mem_role_mem_index_id UNIQUE (roleid, member) auth_mem_mem_role_index_id UNIQUE (member, roleid)
Has OIDs	No
Content
Shared	Yes

pg_auth_time_constraint PNG SVG

Column	Type	Foreign Key
authid	oid	pg_authid.oid
start_day	smallint
start_time	time
end_day	smallint
end_time	time

Indexes
Has OIDs	No
Content
Shared	Yes

pg_authid PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_auth_members.roleid pg_auth_members.member pg_auth_time_constraint.authid pg_class.relowner pg_compression.compowner pg_conversion.conowner pg_database.datdba pg_foreign_data_wrapper.fdwowner pg_foreign_server.srvowner pg_namespace.nspowner pg_opclass.opcowner pg_operator.oprowner pg_proc.proowner pg_stat_last_operation.stasysid pg_stat_last_shoperation.stasysid pg_tablespace.spcowner pg_type.typowner pg_user_mapping.umuser
rolname	name
rolsuper	boolean
rolinherit	boolean
rolcreaterole	boolean
rolcreatedb	boolean
rolcatupdate	boolean
rolcanlogin	boolean
rolconnlimit	integer
rolpassword	text
rolvaliduntil	timestamp_with_time_zone
rolconfig	text[]
rolresqueue	oid	pg_resqueue.oid
rolcreaterextgpfd	boolean
rolcreaterexthttp	boolean
rolcreatewextgpfd	boolean
rolcreaterexthdfs	boolean
rolcreatewexthdfs	boolean

Indexes	auth_id_rolname_index_id UNIQUE (rolname) auth_id_oid_index_id UNIQUE (oid) auth_id_rol_res_queue_index_id (rolresqueue)
Has OIDs	Yes
Content
Shared	Yes

pg_autovacuum PNG SVG

Column	Type	Foreign Key	Reference Keys
vacrelid	oid
enabled	boolean
vac_base_thresh	integer
vac_scale_factor	real
anl_base_thresh	integer
anl_scale_factor	real
vac_cost_delay	integer
vac_cost_limit	integer
freeze_min_age	integer
freeze_max_age	integer

Indexes	autovacuum_relid_index_id UNIQUE (vacrelid)
Has OIDs	No
Content
Shared	No

pg_cast PNG SVG

Column	Type	Foreign Key
oid	oid
castsource	oid	pg_type.oid
casttarget	oid	pg_type.oid
castfunc	oid	pg_proc.oid
castcontext	quoted_char

Indexes	cast_oid_index_id UNIQUE (oid) cast_source_target_index_id UNIQUE (castsource, casttarget)
Has OIDs	Yes
Content
Shared	No

pg_class PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		gp_distribution_policy.localoid gp_fastsequence.objid gp_relation_node.relfilenode_oid pg_appendonly.relid pg_appendonly_alter_column.relid pg_attribute.attrelid pg_class.reltoastrelid pg_class.reltoastidxid pg_constraint.conrelid pg_constraint.confrelid pg_depend.classid pg_depend.refclassid pg_description.classoid pg_exttable.reloid pg_exttable.fmterrtbl pg_foreign_table.reloid pg_index.indexrelid pg_index.indrelid pg_inherits.inhrelid pg_inherits.inhparent pg_partition.parrelid pg_partition_rule.parchildrelid pg_shdepend.classid pg_shdepend.refclassid pg_shdescription.classoid pg_stat_last_operation.classid pg_stat_last_shoperation.classid pg_trigger.tgrelid pg_trigger.tgconstrrelid pg_type.typrelid
relname	name
relnamespace	oid	pg_namespace.oid
reltype	oid	pg_type.oid
relowner	oid	pg_authid.oid
relam	oid	pg_am.oid
relfilenode	oid
reltablespace	oid	pg_tablespace.oid
relpages	integer
reltuples	real
reltoastrelid	oid	pg_class.oid
reltoastidxid	oid	pg_class.oid
relaosegrelid	oid
relaosegidxid	oid
relhasindex	boolean
relisshared	boolean
relkind	quoted_char
relstorage	quoted_char
relnatts	smallint
relchecks	smallint
reltriggers	smallint
relukeys	smallint
relfkeys	smallint
relrefs	smallint
relhasoids	boolean
relhaspkey	boolean
relhasrules	boolean
relhassubclass	boolean
relfrozenxid	xid
relacl	aclitem[]
reloptions	text[]

Indexes	class_oid_index_id UNIQUE (oid) class_name_nsp_index_id UNIQUE (relname, relnamespace)
Has OIDs	Yes
Content
Shared	No

pg_compression PNG SVG

Column	Type	Foreign Key
oid	oid
compname	name
compconstructor	regproc	pg_proc.oid
compdestructor	regproc	pg_proc.oid
compcompressor	regproc	pg_proc.oid
compdecompressor	regproc	pg_proc.oid
compvalidator	regproc	pg_proc.oid
compowner	oid	pg_authid.oid

Indexes	compression_oid_index_id UNIQUE (oid) compression_compname_index_id UNIQUE (compname)
Has OIDs	Yes
Content
Shared	No

pg_constraint PNG SVG

Column	Type	Foreign Key
oid	oid
conname	name
connamespace	oid	pg_namespace.oid
contype	quoted_char
condeferrable	boolean
condeferred	boolean
conrelid	oid	pg_class.oid
contypid	oid	pg_type.oid
confrelid	oid	pg_class.oid
confupdtype	quoted_char
confdeltype	quoted_char
confmatchtype	quoted_char
conkey	smallint[]
confkey	smallint[]
conbin	text
consrc	text

Indexes	constraint_oid_index_id UNIQUE (oid) constraint_name_nsp_index_id (conname, connamespace) constraint_relid_index_id (conrelid) constraint_typid_index_id (contypid)
Has OIDs	Yes
Content
Shared	No

pg_conversion PNG SVG

Column	Type	Foreign Key
oid	oid
conname	name
connamespace	oid	pg_namespace.oid
conowner	oid	pg_authid.oid
conforencoding	integer
contoencoding	integer
conproc	regproc	pg_proc.oid
condefault	boolean

Indexes	conversion_default_index_id UNIQUE (connamespace, conforencoding, contoencoding, oid) conversion_name_nsp_index_id UNIQUE (conname, connamespace) conversion_oid_index_id UNIQUE (oid)
Has OIDs	Yes
Content
Shared	No

pg_database PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_shdepend.dbid
datname	name
datdba	oid	pg_authid.oid
encoding	integer
datistemplate	boolean
datallowconn	boolean
datconnlimit	integer
datlastsysoid	oid
datfrozenxid	xid
dattablespace	oid	pg_tablespace.oid
datconfig	text[]
datacl	aclitem[]

Indexes	database_name_index_id UNIQUE (datname) database_oid_index_id UNIQUE (oid)
Has OIDs	Yes
Content
Shared	Yes

pg_depend PNG SVG

Column	Type	Foreign Key
classid	oid	pg_class.oid
objid	oid
objsubid	integer
refclassid	oid	pg_class.oid
refobjid	oid
refobjsubid	integer
deptype	quoted_char

Indexes	depend_depender_index_id (classid, objid, objsubid) depend_reference_index_id (refclassid, refobjid, refobjsubid)
Has OIDs	No
Content	SEGMENT_LOCAL
Shared	No

pg_description PNG SVG

Column	Type	Foreign Key
objoid	oid
classoid	oid	pg_class.oid
objsubid	integer
description	text

Indexes	description_obj_index_id UNIQUE (objoid, classoid, objsubid)
Has OIDs	No
Content	MASTER_ONLY
Shared	No

pg_extprotocol PNG SVG

Column	Type	Foreign Key
ptcname	name
ptcreadfn	oid	pg_proc.oid
ptcwritefn	oid	pg_proc.oid
ptcvalidatorfn	oid	pg_proc.oid
ptcowner	oid
ptctrusted	bool
ptcacl	aclitem[]

Indexes	extprotocol_oid_index_id UNIQUE (oid) extprotocol_ptcname_index_id UNIQUE (ptcname)
Has OIDs	Yes
Content
Shared	No

pg_exttable PNG SVG

Column	Type	Foreign Key
reloid	oid	pg_class.oid
location	text[]
fmttype	quoted_char
fmtopts	text
command	text
rejectlimit	integer
rejectlimittype	quoted_char
fmterrtbl	oid	pg_class.oid
encoding	integer
writable	boolean

Indexes	ext_table_reloid_index_id UNIQUE (reloid)
Has OIDs	No
Content
Shared	No

pg_filespace PNG SVG

Column	Type	Reference Keys
oid	oid	pg_filespace_entry.fsefsoid pg_tablespace.spcfsoid
fsname	name
fsowner	oid

Indexes	filespace_oid_index_id UNIQUE (oid) filespace_name_index_id UNIQUE (fsname)
Has OIDs	Yes
Content
Shared	Yes

pg_filespace_entry PNG SVG

Column	Type	Foreign Key
fsefsoid	oid	pg_filespace.oid
fsedbid	smallint
fselocation	text

Indexes	file_space_entry_fsefsoid_index_id (fsefsoid) file_space_entry_fsefsoid_fsedbid_index_id UNIQUE (fsefsoid, fsedbid)
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

pg_foreign_data_wrapper PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_foreign_server.srvfdw
fdwname	name
fdwowner	oid	pg_authid.oid
fdwvalidator	oid	pg_proc.oid
fdwacl	aclitem[]
fdwoptions	text[]

Indexes	foreign_data_wrapper_oid_index_id UNIQUE (oid) foreign_data_wrapper_name_index_id UNIQUE (fdwname)
Has OIDs	Yes
Content
Shared	No

pg_foreign_server PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_foreign_table.server pg_user_mapping.umserver
srvname	name
srvowner	oid	pg_authid.oid
srvfdw	oid	pg_foreign_data_wrapper.oid
srvtype	text
srvversion	text
srvacl	aclitem[]
srvoptions	text[]

Indexes	foreign_server_oid_index_id UNIQUE (oid) foreign_server_name_index_id UNIQUE (srvname)
Has OIDs	Yes
Content
Shared	No

pg_foreign_table PNG SVG

Column	Type	Foreign Key
reloid	oid	pg_class.oid
server	oid	pg_foreign_server.oid
tbloptions	text[]

Indexes	foreign_table_rel_oid_index_id UNIQUE (reloid)
Has OIDs	No
Content
Shared	No

pg_index PNG SVG

Column	Type	Foreign Key
indexrelid	oid	pg_class.oid
indrelid	oid	pg_class.oid
indnatts	smallint
indisunique	boolean
indisprimary	boolean
indisclustered	boolean
indisvalid	boolean
indkey	int2vector
indclass	oidvector
indexprs	text
indpred	text

Indexes	index_indrelid_index_id (indrelid) index_relid_index_id UNIQUE (indexrelid)
Has OIDs	No
Content
Shared	No

pg_inherits PNG SVG

Column	Type	Foreign Key
inhrelid	oid	pg_class.oid
inhparent	oid	pg_class.oid
inhseqno	integer

Indexes	inherits_relid_seqno_index_id UNIQUE (inhrelid, inhseqno)
Has OIDs	No
Content
Shared	No

pg_language PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_proc.prolang
lanname	name
lanispl	boolean
lanpltrusted	boolean
lanplcallfoid	oid	pg_proc.oid
lanvalidator	oid	pg_proc.oid
lanacl	aclitem[]

Indexes	language_name_index_id UNIQUE (lanname) language_oid_index_id UNIQUE (oid)
Has OIDs	Yes
Content
Shared	No

pg_largeobject PNG SVG

Column	Type	Foreign Key	Reference Keys
loid	oid
pageno	integer
data	bytea

Indexes	large_object_loid_pageno_index_id UNIQUE (loid, pageno)
Has OIDs	No
Content
Shared	No

pg_listener PNG SVG

Column	Type	Foreign Key	Reference Keys
relname	name
listenerpid	integer
notification	integer

Indexes
Has OIDs	No
Content	MASTER_ONLY
Shared	No

pg_namespace PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_class.relnamespace pg_constraint.connamespace pg_conversion.connamespace pg_opclass.opcnamespace pg_operator.oprnamespace pg_proc.pronamespace pg_type.typnamespace
nspname	name
nspowner	oid	pg_authid.oid
nspacl	aclitem[]

Indexes	namespace_nspname_index_id UNIQUE (nspname) namespace_oid_index_id UNIQUE (oid)
Has OIDs	Yes
Content
Shared	No

pg_opclass PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_amop.amopclaid pg_amproc.amopclaid
opcamid	oid
opcname	name
opcnamespace	oid	pg_namespace.oid
opcowner	oid	pg_authid.oid
opcintype	oid
opcdefault	boolean
opckeytype	oid

Indexes	opclass_am_name_nsp_index_id UNIQUE (opcamid, opcname, opcnamespace) opclass_oid_index_id UNIQUE (oid)
Has OIDs	Yes
Content
Shared	No

pg_operator PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_aggregate.aggsortop pg_amop.amopopr pg_operator.oprcom pg_operator.oprnegate pg_operator.oprlsortop pg_operator.oprrsortop pg_operator.oprltcmpop pg_operator.oprgtcmpop pg_statistic.staop1 pg_statistic.staop2 pg_statistic.staop3 pg_statistic.staop4
oprname	name
oprnamespace	oid	pg_namespace.oid
oprowner	oid	pg_authid.oid
oprkind	quoted_char
oprcanhash	boolean
oprleft	oid	pg_type.oid
oprright	oid	pg_type.oid
oprresult	oid	pg_type.oid
oprcom	oid	pg_operator.oid
oprnegate	oid	pg_operator.oid
oprlsortop	oid	pg_operator.oid
oprrsortop	oid	pg_operator.oid
oprltcmpop	oid	pg_operator.oid
oprgtcmpop	oid	pg_operator.oid
oprcode	regproc	pg_proc.oid
oprrest	regproc	pg_proc.oid
oprjoin	regproc	pg_proc.oid

Indexes	operator_oid_index_id UNIQUE (oid) operator_name_nsp_index_id UNIQUE (oprname, oprleft, oprright, oprnamespace)
Has OIDs	Yes
Content
Shared	No

pg_partition PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_partition_encoding.parencoid pg_partition_rule.paroid
parrelid	oid	pg_class.oid
parkind	quoted_char
parlevel	smallint
paristemplate	boolean
parnatts	smallint
paratts	int2vector
parclass	oidvector

Indexes	partition_oid_index_id UNIQUE (oid) partition_parrelid_index_id (parrelid) partition_parrelid_parlevel_paristemplate_index_id (parrelid, parlevel, paristemplate)
Has OIDs	Yes
Content	MASTER_ONLY
Shared	No

pg_partition_encoding PNG SVG

Column	Type	Foreign Key
parencoid	oid	pg_partition.oid
parencattnum	smallint
parencattoptions	text[]

Indexes	partition_encoding_parencoid_attnum_index_id UNIQUE (parencoid, parencattnum) partition_encoding_parencoid_index_id (parencoid)
Has OIDs	No
Content
Shared	No

pg_partition_rule PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_partition_rule.parparentrule
paroid	oid	pg_partition.oid
parchildrelid	oid	pg_class.oid
parparentrule	oid	pg_partition_rule.oid
parname	name
parisdefault	boolean
parruleord	smallint
parrangestartincl	boolean
parrangeendincl	boolean
parrangestart	text
parrangeend	text
parrangeevery	text
parlistvalues	text
parreloptions	text[]
partemplatespace	oid	pg_tablespace.oid

Indexes	partition_rule_oid_index_id UNIQUE (oid) partition_rule_parchildrelid_index_id (parchildrelid) partition_rule_parchildrelid_parparentrule_parruleord_index_id (parchildrelid, parparentrule, parruleord) partition_rule_paroid_parparentrule_parruleord_index_id (paroid, parparentrule, parruleord)
Has OIDs	Yes
Content	MASTER_ONLY
Shared	No

pg_pltemplate PNG SVG

Column	Type	Foreign Key	Reference Keys
tmplname	name
tmpltrusted	boolean
tmplhandler	text
tmplvalidator	text
tmpllibrary	text
tmplacl	aclitem[]

Indexes	pl_template_name_index_id UNIQUE (tmplname)
Has OIDs	No
Content
Shared	Yes

pg_proc PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_aggregate.aggfnoid pg_aggregate.aggtransfn pg_aggregate.agginvtransfn pg_aggregate.aggprelimfn pg_aggregate.agginvprelimfn pg_aggregate.aggfinalfn pg_am.aminsert pg_am.ambeginscan pg_am.amgettuple pg_am.amgetmulti pg_am.amrescan pg_am.amendscan pg_am.ammarkpos pg_am.amrestrpos pg_am.ambuild pg_am.ambulkdelete pg_am.amvacuumcleanup pg_am.amcostestimate pg_am.amoptions pg_amproc.amproc pg_cast.castfunc pg_compression.compconstructor pg_compression.compdestructor pg_compression.compcompressor pg_compression.compdecompressor pg_compression.compvalidator pg_conversion.conproc pg_extprotocol.ptcreadfn pg_extprotocol.ptcwritefn pg_extprotocol.ptcvalidatorfn pg_foreign_data_wrapper.fdwvalidator pg_language.lanplcallfoid pg_language.lanvalidator pg_operator.oprcode pg_operator.oprrest pg_operator.oprjoin pg_proc_callback.profnoid pg_proc_callback.procallback pg_trigger.tgfoid pg_type.typinput pg_type.typoutput pg_type.typreceive pg_type.typsend pg_type.typanalyze pg_window.winfnoid pg_window.winfunc pg_window.winprefunc pg_window.winfinfunc
proname	name
pronamespace	oid	pg_namespace.oid
proowner	oid	pg_authid.oid
prolang	oid	pg_language.oid
proisagg	boolean
prosecdef	boolean
proisstrict	boolean
proretset	boolean
provolatile	quoted_char
pronargs	smallint
prorettype	oid	pg_type.oid
proiswin	boolean
proargtypes	oidvector
proallargtypes	oid[]
proargmodes	quoted_char[]
proargnames	text[]
prosrc	text
probin	bytea
proacl	aclitem[]
prodataaccess	quoted_char
provariadic	oid

Indexes	procedure_oid_index_id UNIQUE (oid) procedure_name_args_nsp_index_id UNIQUE (proname, proargtypes, pronamespace)
Has OIDs	Yes
Content
Shared	No

pg_proc_callback PNG SVG

Column	Type	Foreign Key
profnoid	regproc	pg_proc.oid
procallback	regproc	pg_proc.oid
promethod	quoted_char

Indexes	proc_callback_profnoid_promethod_index_id UNIQUE (profnoid, promethod)
Has OIDs	No
Content
Shared	No

pg_resourcetype PNG SVG

Column	Type	Reference Keys
oid	oid
resname	name
restypid	smallint	pg_resqueuecapability.restypid
resrequired	boolean
reshasdefault	boolean
reshasdisable	boolean
resdefaultsetting	text
resdisabledsetting	text

Indexes	resource_type_oid_index_id UNIQUE (oid) resource_type_restypid_index_id UNIQUE (restypid) resource_type_resname_index_id UNIQUE (resname)
Has OIDs	Yes
Content
Shared	Yes

pg_resqueue PNG SVG

Column	Type	Reference Keys
oid	oid	pg_authid.rolresqueue pg_resqueuecapability.resqueueid
rsqname	name
rsqcountlimit	real
rsqcostlimit	real
rsqovercommit	boolean
rsqignorecostlimit	real

Indexes	res_queue_oid_index_id UNIQUE (oid) res_queue_rsqname_index_id UNIQUE (rsqname)
Has OIDs	Yes
Content
Shared	Yes

pg_resqueuecapability PNG SVG

Column	Type	Foreign Key
oid	oid
resqueueid	oid	pg_resqueue.oid
restypid	smallint	pg_resourcetype.restypid
ressetting	text

Indexes	res_queue_capability_oid_index_id UNIQUE (oid) res_queue_capability_resqueueid_index_id (resqueueid) res_queue_capability_restypid_index_id (restypid)
Has OIDs	Yes
Content
Shared	Yes

pg_rewrite PNG SVG

Column	Type	Foreign Key
oid	oid
rulename	name
ev_class	oid	pg_attribute.attrelid
ev_attr	smallint
ev_type	quoted_char
is_instead	boolean
ev_qual	text
ev_action	text

Indexes	rewrite_oid_index_id UNIQUE (oid) rewrite_rel_rulename_index_id UNIQUE (ev_class, rulename)
Has OIDs	Yes
Content
Shared	No

pg_shdepend PNG SVG

Column	Type	Foreign Key
dbid	oid	pg_database.oid
classid	oid	pg_class.oid
objid	oid
refclassid	oid	pg_class.oid
refobjid	oid
deptype	quoted_char

Indexes	shared_depend_depender_index_id (dbid, classid, objid) shared_depend_reference_index_id (refclassid, refobjid)
Has OIDs	No
Content	SEGMENT_LOCAL
Shared	Yes

pg_shdescription PNG SVG

Column	Type	Foreign Key
objoid	oid
classoid	oid	pg_class.oid
description	text

Indexes	shared_description_obj_index_id UNIQUE (objoid, classoid)
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

pg_stat_last_operation PNG SVG

Column	Type	Foreign Key
classid	oid	pg_class.oid
objid	oid
staactionname	name
stasysid	oid	pg_authid.oid
stausename	name
stasubtype	text
statime	timestamp_with_time_zone

Indexes	stat_last_op_classid_objid_index_id (classid, objid) stat_last_op_classid_objid_staactionname_index_id UNIQUE (classid, objid, staactionname)
Has OIDs	No
Content	MASTER_ONLY
Shared	No

pg_stat_last_shoperation PNG SVG

Column	Type	Foreign Key
classid	oid	pg_class.oid
objid	oid
staactionname	name
stasysid	oid	pg_authid.oid
stausename	name
stasubtype	text
statime	timestamp_with_time_zone

Indexes	stat_last_sh_op_classid_objid_index_id (classid, objid) stat_last_sh_op_classid_objid_staactionname_index_id UNIQUE (classid, objid, staactionname)
Has OIDs	No
Content	MASTER_ONLY
Shared	Yes

pg_statistic PNG SVG

Column	Type	Foreign Key
starelid	oid	pg_attribute.attrelid
staattnum	smallint
stanullfrac	real
stawidth	integer
stadistinct	real
stakind1	smallint
stakind2	smallint
stakind3	smallint
stakind4	smallint
staop1	oid	pg_operator.oid
staop2	oid	pg_operator.oid
staop3	oid	pg_operator.oid
staop4	oid	pg_operator.oid
stanumbers1	real[]
stanumbers2	real[]
stanumbers3	real[]
stanumbers4	real[]
stavalues1	text
stavalues2	text
stavalues3	text
stavalues4	text

Indexes	statistic_relid_attnum_index_id UNIQUE (starelid, staattnum)
Has OIDs	No
Content	SEGMENT_LOCAL
Shared	No

pg_tablespace PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_class.reltablespace pg_database.dattablespace pg_partition_rule.partemplatespace
spcname	name
spcowner	oid	pg_authid.oid
spclocation	text
spcacl	aclitem[]
spcprilocations	text[]
spcmirlocations	text[]
spcfsoid	oid	pg_filespace.oid

Indexes	tablespace_oid_index_id UNIQUE (oid) tablespace_name_index_id UNIQUE (spcname)
Has OIDs	Yes
Content
Shared	Yes

pg_trigger PNG SVG

Column	Type	Foreign Key
oid	oid
tgrelid	oid	pg_class.oid
tgname	name
tgfoid	oid	pg_proc.oid
tgtype	smallint
tgenabled	boolean
tgisconstraint	boolean
tgconstrname	name
tgconstrrelid	oid	pg_class.oid
tgdeferrable	boolean
tginitdeferred	boolean
tgnargs	smallint
tgattr	int2vector
tgargs	bytea

Indexes	trigger_constr_name_index_id (tgconstrname) trigger_constr_relid_index_id (tgconstrrelid) trigger_relid_name_index_id UNIQUE (tgrelid, tgname) trigger_oid_index_id UNIQUE (oid)
Has OIDs	Yes
Content
Shared	No

pg_type PNG SVG

Column	Type	Foreign Key	Reference Keys
oid	oid		pg_aggregate.aggtranstype pg_amop.amopsubtype pg_amproc.amprocsubtype pg_attribute.atttypid pg_cast.castsource pg_cast.casttarget pg_class.reltype pg_constraint.contypid pg_operator.oprleft pg_operator.oprright pg_operator.oprresult pg_proc.prorettype pg_type_encoding.typid
typname	name
typnamespace	oid	pg_namespace.oid
typowner	oid	pg_authid.oid
typlen	smallint
typbyval	boolean
typtype	quoted_char
typisdefined	boolean
typdelim	quoted_char
typrelid	oid	pg_class.oid
typelem	oid
typinput	regproc	pg_proc.oid
typoutput	regproc	pg_proc.oid
typreceive	regproc	pg_proc.oid
typsend	regproc	pg_proc.oid
typanalyze	regproc	pg_proc.oid
typalign	quoted_char
typstorage	quoted_char
typnotnull	boolean
typbasetype	oid
typtypmod	integer
typndims	integer
typdefaultbin	text
typdefault	text

Indexes	type_oid_index_id UNIQUE (oid) type_name_nsp_index_id UNIQUE (typname, typnamespace)
Has OIDs	Yes
Content
Shared	No

pg_type_encoding PNG SVG

Column	Type	Foreign Key	Reference Keys
typid	oid	pg_type.oid
typoptions	text[]

Indexes	type_encoding_typid_index_id UNIQUE (typid)
Has OIDs	No
Content
Shared	No

pg_user_mapping PNG SVG

Column	Type	Foreign Key
oid	oid
umuser	oid	pg_authid.oid
umserver	oid	pg_foreign_server.oid
umoptions	text[]

Indexes	user_mapping_oid_index_id UNIQUE (oid) user_mapping_user_server_index_id UNIQUE (umuser, umserver)
Has OIDs	Yes
Content
Shared	No

pg_window PNG SVG

Column	Type	Foreign Key
winfnoid	regproc	pg_proc.oid
winrequireorder	boolean
winallowframe	boolean
winpeercount	boolean
wincount	boolean
winfunc	regproc	pg_proc.oid
winprefunc	regproc	pg_proc.oid
winpretype	oid
winfinfunc	regproc	pg_proc.oid
winkind	quoted_char
winframemakerfunc	regproc

Indexes	window_winfnoid_index_id UNIQUE (winfnoid)
Has OIDs	No
Content
Shared	No