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_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. |
