information_schema

Tables

Below is a list of supported Postgres system tables which are stored in the schema information_schema. The supported version is Postgres 12. Click on a table in the list, to find additional information in the official Postgres documentation.

Columns

information_schema.schemata

  • catalog_name
  • schema_name
This table contains one row for every data source configured in Contiamo. The schema_name is the name of the data source or virtual db. The catalog_name is the UUID of the project currently connected to. catalog_name can be used as a prefix for data source names when querying data (though this is optional). For example SELECT * FROM <`catalog_name`>.<`schema_name`>.sales_table
(Postgres doc -> schemata)

information_schema.tables

  • table_catalog (project UUID)
  • table_schema
  • table_name
  • table_type
This table is used to get information about the tables and views to which your data sources are connected. Also, virtual data sources which are created in the Contiamo Data Catalog are stored in this table.
(Postgres doc -> tables)

information_schema.columns

  • table_catalog
  • table_schema
  • table_name
  • column_name
  • ordinal_position
  • is_nullable
  • data_type
Information about columns in your data landscape is shown in this table.
(Postgres doc -> columns)

information_schema.character_sets

  • character_set_catalog
  • character_set_schema
  • character_set_name
This table stores the encodings which can be used. Contiamo supports UTF8 only.
(Postgres doc -> character_sets)

information_schema.referential_constraints

  • constraint_catalog
  • constraint_schema
  • constraint_name
  • unique_constraint_catalog
  • unique_constraint_schema
  • unique_constraint_name
This table stores foreign key constraints. Those are not supported by Contiamo, the table is empty.
(Postgres doc -> referential_constraints)

information_schema.table_constraints

  • constraint_catalog
  • constraint_schema
  • constraint_name
  • table_catalog
  • table_schema
  • table_name
  • constraint_type
  • is_deferrable
  • initially_deferred
This table stores constraints what is not supported by Contiamo. The table is empty.
(Postgres doc -> table_constraints)

information_schema.key_column_usage

  • constraint_catalog
  • constraint_schema
  • constraint_name
  • table_catalog
  • table_schema
  • table_name
  • column_name
  • ordinal_position
  • position_in_unique_constraint
This table stores constraints what is not supported by Contiamo. The table is empty.
(Postgres doc -> key_column_usage)