> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# PostgreSQL Virtual Catalog

<a id="sql-vc-pg" />

## 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](/content/catalogs#sql-vc) 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](https://postgis.net/docs/using_postgis_dbmanagement.html#geometry_columns) | Columns of tables & views that have a GEOMETRY data type. |
| [pg\_attrdef](https://www.postgresql.org/docs/current/catalog-pg-attrdef.html) | Columns that have default values. |
| [pg\_attribute](https://www.postgresql.org/docs/current/catalog-pg-attribute.html) | Columns of tables & views and their respective types & statistics. |
| [pg\_auth\_members](https://www.postgresql.org/docs/current/catalog-pg-auth-members.html) | Users & roles and their granted roles, one record per user/role or role/role pair. |
| [pg\_authid](https://www.postgresql.org/docs/current/catalog-pg-authid.html) | Users & roles and their respective attributes. |
| [pg\_class](https://www.postgresql.org/docs/current/catalog-pg-class.html) | Tables & views and their respective types and column counts. |
| [pg\_constraint](https://www.postgresql.org/docs/current/catalog-pg-constraint.html) | Primary & foreign keys. |
| [pg\_database](https://www.postgresql.org/docs/current/catalog-pg-database.html) | Contains a single record with the database name and information. |
| [pg\_default\_acl](https://www.postgresql.org/docs/current/catalog-pg-default-acl.html) | Contains a single record with the default table ACL for the `public` role. |
| [pg\_description](https://www.postgresql.org/docs/current/catalog-pg-description.html) | Comments for tables & views. |
| [pg\_index](https://www.postgresql.org/docs/current/catalog-pg-index.html) | Indexes and their respective configurations. |
| [pg\_indexes](https://www.postgresql.org/docs/current/view-pg-indexes.html) | Indexes and their corresponding schemas. |
| [pg\_language](https://www.postgresql.org/docs/current/catalog-pg-language.html) | Contains a single record with the supported procedure language, `SQL`. |
| [pg\_matviews](https://www.postgresql.org/docs/current/view-pg-matviews.html) | Materialized views and their backing SQL, if created using SQL. |
| [pg\_namespace](https://www.postgresql.org/docs/current/catalog-pg-namespace.html) | Schemas, containing all database objects. |
| [pg\_proc](https://www.postgresql.org/docs/current/catalog-pg-proc.html) | Scalar, aggregate, window, and user-defined functions. |
| [pg\_roles](https://www.postgresql.org/docs/current/view-pg-roles.html) | Users & roles and their respective attributes. |
| [pg\_stat\_all\_tables](https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ALL-TABLES-VIEW) | Row & byte counts for each object in the database. |
| [pg\_stats](https://www.postgresql.org/docs/current/view-pg-stats.html) | Columns of tables & views and their respective types. |
| [pg\_tables](https://www.postgresql.org/docs/current/view-pg-tables.html) | Tables & views. |
| [pg\_timezone\_abbrevs](https://www.postgresql.org/docs/current/view-pg-timezone-abbrevs.html) | Contains a single record with the supported UTC timezone and its GMT offset. |
| [pg\_timezone\_names](https://www.postgresql.org/docs/current/view-pg-timezone-names.html) | Contains a single record with the supported UTC timezone name, abbreviation, and its GMT offset. |
| [pg\_type](https://www.postgresql.org/docs/current/catalog-pg-type.html) | Supported PostgreSQL column data types mapped to Kinetica types. |
| [pg\_user](https://www.postgresql.org/docs/current/view-pg-user.html) | Users and their respective attributes, from `pg_authid`. |
| [pg\_views](https://www.postgresql.org/docs/current/view-pg-views.html) | Logical views and their backing queries. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.