risingwave_frontend/catalog/system_catalog/information_schema/
schemata.rs

1// Copyright 2025 RisingWave Labs
2//
3// Licensed under the Apache License, Version 2.0 (the "License");
4// you may not use this file except in compliance with the License.
5// You may obtain a copy of the License at
6//
7//     http://www.apache.org/licenses/LICENSE-2.0
8//
9// Unless required by applicable law or agreed to in writing, software
10// distributed under the License is distributed on an "AS IS" BASIS,
11// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12// See the License for the specific language governing permissions and
13// limitations under the License.
14
15use risingwave_common::types::Fields;
16use risingwave_frontend_macro::system_catalog;
17
18/// The view schemata contains all schemas in the current database that the current user has access to (by way of being the owner or having some privilege).
19/// Ref: [`https://www.postgresql.org/docs/current/infoschema-schemata.html`]
20#[system_catalog(
21    view,
22    "information_schema.schemata",
23    "SELECT CURRENT_DATABASE() AS catalog_name,
24            s.name AS schema_name,
25            u.name AS schema_owner,
26            NULL,
27            NULL,
28            NULL,
29            NULL
30        FROM rw_catalog.rw_schemas s
31        JOIN rw_catalog.rw_users u ON s.owner = u.id
32        WHERE has_schema_privilege(s.name, 'CREATE, USAGE')
33        ORDER BY catalog_name, schema_name"
34)]
35#[derive(Fields)]
36struct Schemata {
37    catalog_name: String,
38    schema_name: String,
39    schema_owner: String,
40    default_character_set_catalog: String,
41    default_character_set_schema: String,
42    default_character_set_name: String,
43    sql_path: String,
44}