feat: add SYS.USER_CONS_COLUMNS compatible view

3296442201 · 3296442201 · commit c2209bb59088 · 2026-04-09T18:47:01.000+08:00
diff --git a/contrib/ivorysql_ora/src/sysview/sysview--1.0.sql b/contrib/ivorysql_ora/src/sysview/sysview--1.0.sql
@@ -1213,4 +1213,29 @@ CREATE OR REPLACE VIEW SYS.USER_CONS_COLUMNS AS
 		AND C.RELNAMESPACE != 'INFORMATION_SCHEMA'::REGNAMESPACE::OID
 ORDER BY
 	TABLE_NAME, CONSTRAINT_NAME, COLUMN_NAME
-;
+;
+
+/* USER_CONS_COLUMNS */
+CREATE OR REPLACE VIEW SYS.USER_CONS_COLUMNS AS
+SELECT
+    c.relname AS TABLE_NAME,
+    a.attname AS COLUMN_NAME,
+    a.attnum AS COLUMN_ID,
+    t.typname AS DATA_TYPE,
+    a.atttypmod AS DATA_LENGTH,
+    a.attnotnull AS NULLABLE,
+    CASE WHEN i.indisprimary THEN 'P' ELSE NULL END AS CONSTRAINT_TYPE,
+    d.description AS COMMENTS
+FROM
+    pg_class c
+    JOIN pg_attribute a ON c.oid = a.attrelid
+    JOIN pg_type t ON a.atttypid = t.oid
+    LEFT JOIN pg_index i ON c.oid = i.indrelid AND a.attnum = i.indkey[0]
+    LEFT JOIN pg_description d ON c.oid = d.objoid AND a.attnum = d.objsubid
+WHERE
+    c.relowner = (SELECT usesysid FROM pg_user WHERE usename = current_user)
+    AND c.relkind IN ('r', 'v')
+    AND a.attnum > 0
+    AND NOT a.attisdropped
+ORDER BY
+    c.relname, a.attnum;
