risingwave_frontend/catalog/system_catalog/pg_catalog/
pg_attribute.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 catalog `pg_attribute` stores information about table columns. There will be exactly one
19/// `pg_attribute` row for every column in every table in the database. (There will also be
20/// attribute entries for indexes, and indeed all objects that have `pg_class` entries.)
21/// Ref: [`https://www.postgresql.org/docs/current/catalog-pg-attribute.html`]
22///
23/// In RisingWave, we simply make it contain the columns of the view and all the columns of the
24/// tables that are not internal tables.
25#[system_catalog(
26    view,
27    "pg_catalog.pg_attribute",
28    "SELECT c.relation_id AS attrelid,
29            c.name AS attname,
30            c.type_oid AS atttypid,
31            CASE
32              WHEN c.udt_type = 'list' THEN 1::int2
33              ELSE 0::int2
34            END AS attndims,
35            c.type_len AS attlen,
36            c.position::smallint AS attnum,
37            false AS attnotnull,
38            false AS atthasdef,
39            false AS attisdropped,
40            ''::varchar AS attidentity,
41            CASE
42              WHEN c.is_generated THEN 's'::varchar
43              ELSE ''::varchar
44            END AS attgenerated,
45            -1 AS atttypmod,
46            NULL::text[] AS attoptions,
47            0 AS attcollation
48        FROM rw_catalog.rw_columns c
49        WHERE c.is_hidden = false"
50)]
51#[derive(Fields)]
52struct PgAttribute {
53    attrelid: i32,
54    attname: String,
55    atttypid: i32,
56    attndims: i16,
57    attlen: i16,
58    attnum: i16,
59    attnotnull: bool,
60    atthasdef: bool,
61    attisdropped: bool,
62    attidentity: String,
63    attgenerated: String,
64    atttypmod: i32,
65    attoptions: Vec<String>,
66    attcollation: i32,
67}
risingwave_frontend/catalog/system_catalog/pg_catalog/pg_attribute.rs

risingwave_frontend/catalog/system_catalog/pg_catalog/
pg_attribute.rs
