github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/delegate/show_databases.go (about)

     1  // Copyright 2019 The Cockroach Authors.
     2  //
     3  // Use of this software is governed by the Business Source License
     4  // included in the file licenses/BSL.txt.
     5  //
     6  // As of the Change Date specified in that file, in accordance with
     7  // the Business Source License, use of this software will be governed
     8  // by the Apache License, Version 2.0, included in the file
     9  // licenses/APL.txt.
    10  
    11  package delegate
    12  
    13  import "github.com/cockroachdb/cockroach/pkg/sql/sem/tree"
    14  
    15  func (d *delegator) delegateShowDatabases(stmt *tree.ShowDatabases) (tree.Statement, error) {
    16  	query := `SELECT
    17    DISTINCT
    18    catalog_name AS database_name`
    19  
    20  	if stmt.WithComment {
    21  		query += `,
    22    shobj_description(oid, 'pg_database') AS comment`
    23  	}
    24  
    25  	query += `
    26  FROM
    27    "".information_schema.schemata`
    28  
    29  	if stmt.WithComment {
    30  		query += `
    31    JOIN pg_database ON
    32      schemata.catalog_name = pg_database.datname`
    33  	}
    34  
    35  	query += `
    36    ORDER BY 1`
    37  
    38  	return parse(query)
    39  }