risingwave_frontend/catalog/system_catalog/pg_catalog/
pg_matviews.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 `pg_matviews` provides access to useful information about each materialized view in the
19/// database.
20/// Ref: [`https://www.postgresql.org/docs/current/view-pg-matviews.html`]
21#[system_catalog(
22    view,
23    "pg_catalog.pg_matviews",
24    "SELECT
25       s.name as schemaname,
26       mv.name as matviewname,
27       mv.owner as matviewowner,
28       NULL AS tablespace,
29       false AS hasindexes,
30       true AS ispopulated,
31       mv.definition as definition
32     FROM rw_materialized_views mv
33     JOIN rw_schemas s ON mv.schema_id = s.id"
34)]
35#[derive(Fields)]
36struct PgMatview {
37    schemaname: String,
38    matviewname: String,
39    matviewowner: i32,
40    tablespace: Option<String>,
41    hasindexes: bool,
42    ispopulated: bool,
43    definition: String,
44}