Contiamo
Contiamo.comGet the Data Hub
Search…
Contiamo Docs
Contiamo Docs
Setup and deployment
Installing Contiamo
Single sign on (SSO)
Connecting your external data sources
Data source overview
Workbench: Data virtualization
Introduction
Uploading data
Querying data
Creating views and materializations
Data catalog
Introduction
Setting up your catalog
Setting permissions
Searching for data
Adding metadata
Consuming data in external tools
External tool overview
Supported Postgres system tables
information_schema
pg_catalog
Powered By GitBook
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)
Consuming data in external tools - Previous
Supported Postgres system tables
Next
pg_catalog
Last modified 1yr ago
Copy link
Contents
Tables
Columns
information_schema.schemata
information_schema.tables
information_schema.columns
information_schema.character_sets
information_schema.referential_constraints
information_schema.table_constraints
information_schema.key_column_usage