pg_catalog
. The supported version is Postgres 12.Please note that for the system tables all object identifiers (OIDs) are auto-generated. Their integrity and references are consistent within your query state, but the values are not stored and may change every time you query Contiamo. For this reason, you should not cache or store OIDs for later use in succeeding queries.
relam
, relhasrules
and relhassubclass
will always have a default value. relhasoids
is no longer supported in Postgres 12 but is kept due to legacy compatibility with the value false
.attisdropped
column is not supported and will always be false
. Default expressions for columns are not supported so atthasdef
will always be false
. The not null constraint and identity columns are not supported either, so attnotnull
and attidentity
will return false
or a null value.pg_index
table stores information about indices inside the database. This table is empty.pg_am
table stores information about access methods for indices inside the database. This table is empty.varchar
. The field typtype
will always show b
for base type. Composite types or enums and domains are not supported. Array types are not shown, so typelem
always returns 0. Also not supported are the columns typreceive
and typsend
which store a relation to the conversion function of input and output elements for a type. typtypmod
as well as typbasetype
are used for domains, which are not supported either.