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