PostgreSQL Virtual Catalog

Overview

The PostgreSQL Virtual Catalog tables represent Kinetica’s implementation of the PostgreSQL system catalog tables found in the pg_catalog schema. These These tables contain information about the database’s objects, relationships, & permissions. Most of the metadata tables are implemented as logical views of the Kinetica Virtual Catalog tables, while some are logical views of other PostgreSQL Virtual Catalog logical views. As such, they will be updated automatically to reflect changes in the database structure and processing state. The information returned when querying the virtual catalogs is automatically filtered by the permissions of the querying user. For instance, regular users will only see the tables & views to which they have access when querying a virtual catalog table that lists all of the tables in the database, while system administrators will see all tables & views.

Catalog View List

The PostgreSQL Virtual Catalog tables reside in the pg_catalog schema.

Virtual Catalog Table	Description
geometry_columns	Columns of tables & views that have a GEOMETRY data type.
pg_attrdef	Columns that have default values.
pg_attribute	Columns of tables & views and their respective types & statistics.
pg_auth_members	Users & roles and their granted roles, one record per user/role or role/role pair.
pg_authid	Users & roles and their respective attributes.
pg_class	Tables & views and their respective types and column counts.
pg_constraint	Primary & foreign keys.
pg_database	Contains a single record with the database name and information.
pg_default_acl	Contains a single record with the default table ACL for the `public` role.
pg_description	Comments for tables & views.
pg_index	Indexes and their respective configurations.
pg_indexes	Indexes and their corresponding schemas.
pg_language	Contains a single record with the supported procedure language, `SQL`.
pg_matviews	Materialized views and their backing SQL, if created using SQL.
pg_namespace	Schemas, containing all database objects.
pg_proc	Scalar, aggregate, window, and user-defined functions.
pg_roles	Users & roles and their respective attributes.
pg_stat_all_tables	Row & byte counts for each object in the database.
pg_stats	Columns of tables & views and their respective types.
pg_tables	Tables & views.
pg_timezone_abbrevs	Contains a single record with the supported UTC timezone and its GMT offset.
pg_timezone_names	Contains a single record with the supported UTC timezone name, abbreviation, and its GMT offset.
pg_type	Supported PostgreSQL column data types mapped to Kinetica types.
pg_user	Users and their respective attributes, from `pg_authid`.
pg_views	Logical views and their backing queries.

​Overview

​Catalog View List

Overview

Catalog View List