On this page
Warning:CockroachDB v19.1 is no longer supported. For more details, see the Release Support Policy.
SHOW DATABASES statement lists all databases in the CockroachDB cluster.
No privileges are required to list the databases in the CockroachDB cluster.
> SHOW DATABASES;
+---------------+ | database_name | +---------------+ | defaultdb | | postgres | | system | +---------------+ (3 rows)
New clusters and existing clusters upgraded to v2.1 or later will include three auto-generated databases, with the following purposes:
defaultdbdatabase is used if a client does not specify a database in the connection parameters.
An empty database called
postgresis provided for compatibility with Postgres client applications that require it.
systemdatabase contains CockroachDB metadata and is read-only.
defaultdb databases can be deleted if they are not needed.