On this page 
Warning:
CockroachDB v20.2 is no longer supported as of May 10, 2022. For more details, refer to the Release Support Policy.
CockroachDB includes a set of system catalogs that provide non-stored data to client applications.
The following system catalogs are available as schemas preloaded to every database:
information_schema, a schema provided for compatibility with the SQL standard.crdb_internal, a schema with information about CockroachDB internals.pg_catalog, a schema provided for compatibility with PostgreSQL.- New in v20.2:
pg_extension, a schema with information about CockroachDB extensions.
Warning:
Tables in the system catalogs have varying levels of stability. Not all system catalog tables are meant for programmatic purposes.
To see all of the system catalogs for the current database, you can use a SHOW SCHEMAS statement:
> SHOW SCHEMAS;
schema_name | owner
---------------------+--------
crdb_internal | NULL
information_schema | NULL
pg_catalog | NULL
pg_extension | NULL
public | admin
(5 rows)
See also
Was this helpful?
