docs

billy1624 · billy1624 · commit d615448699c2 · 2023-04-24T17:18:48.000+08:00
diff --git a/src/postgres/query/schema.rs b/src/postgres/query/schema.rs
@@ -44,6 +44,21 @@ pub(crate) fn select_table_and_view() -> SelectStatement {
                         .equals((PgClass::Table, PgClass::Oid)),
                 )
                 .add(
+                    // List of possible value of the `relkind` column.
+                    // ========
+                    // r = ordinary table
+                    // i = index
+                    // S = sequence
+                    // t = TOAST table
+                    // v = view
+                    // m = materialized view
+                    // c = composite type
+                    // f = foreign table
+                    // p = partitioned table
+                    // I = partitioned index
+                    // Extracted from https://www.postgresql.org/docs/current/catalog-pg-class.html
+                    //
+                    // We want to select tables and views only.
                     Expr::col((PgClass::Table, PgClass::Relkind))
                         .is_in(["r", "t", "v", "m", "f", "p"]),
                 ),
