Merge pull request taozhi8833998#2626 from taozhi8833998/feat-text-search-type-pg

taozhi8833998 · web-flow · commit d619d1ac3fd4 · 2026-01-06T13:54:44.000+08:00
feat: support text search type in pg
diff --git a/pegjs/postgresql.pegjs b/pegjs/postgresql.pegjs
@@ -5787,6 +5787,8 @@ KW_TEXT     = "TEXT"i     !ident_start { return 'TEXT'; }
 KW_MEDIUMTEXT = "MEDIUMTEXT"i  !ident_start { return 'MEDIUMTEXT'; }
 KW_LONGTEXT  = "LONGTEXT"i  !ident_start { return 'LONGTEXT'; }
 KW_MEDIUMINT = "MEDIUMINT"i !ident_start { return 'MEDIUMINT'; }
+KW_TSVECTOR = "TSVECTOR"i !ident_start { return 'TSVECTOR'; }
+KW_TSQUERY = "TSQUERY"i !ident_start { return 'TSQUERY'; }
 KW_BIGINT   = "BIGINT"i   !ident_start { return 'BIGINT'; }
 KW_ENUM     = "ENUM"i   !ident_start { return 'ENUM'; }
 KW_FLOAT   = "FLOAT"i   !ident_start { return 'FLOAT'; }
@@ -6309,6 +6311,7 @@ text_type
     /* =>  data_type */
     return { dataType: `${t}${s ? '[]' : ''}` }
   }
+  / t:(KW_TSVECTOR / KW_TSQUERY) {/* =>  data_type */  return { dataType: t }; }
 
 uuid_type
   = t:KW_UUID {/* =>  data_type */  return { dataType: t }}
diff --git a/test/postgres.spec.js b/test/postgres.spec.js
@@ -1950,6 +1950,16 @@ describe('Postgres', () => {
         'ALTER TABLE "table_name" REPLICA IDENTITY FULL',
       ]
     },
+    {
+      title: 'tsvector data type',
+      sql: [
+        `CREATE TABLE test_table (
+            id int not null,
+            vector tsvector
+        );`,
+        'CREATE TABLE "test_table" (id INT NOT NULL, vector TSVECTOR)'
+      ]
+    },
   ]
   function neatlyNestTestedSQL(sqlList){
     sqlList.forEach(sqlInfo => {
