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.
relhassubclasswill always have a default value.
relhasoidsis no longer supported in Postgres 12 but is kept due to legacy compatibility with the value
attisdroppedcolumn is not supported and will always be
false. Default expressions for columns are not supported so
atthasdefwill always be
false. The not null constraint and identity columns are not supported either, so
falseor a null value.
pg_indextable stores information about indices inside the database. This table is empty.
pg_amtable stores information about access methods for indices inside the database. This table is empty.
varchar. The field
typtypewill always show
bfor base type. Composite types or enums and domains are not supported. Array types are not shown, so
typelemalways returns 0. Also not supported are the columns
typsendwhich store a relation to the conversion function of input and output elements for a type.
typtypmodas well as
typbasetypeare used for domains, which are not supported either.