stackrender
diff --git a/‎pegjs/postgresql.pegjs‎
Lines changed: 28 additions & 0 deletions b/‎pegjs/postgresql.pegjs‎
Lines changed: 28 additions & 0 deletions
diff --git a/‎src/command.js‎
Lines changed: 3 additions & 0 deletions b/‎src/command.js‎
Lines changed: 3 additions & 0 deletions
diff --git a/‎test/postgres.spec.js‎
Lines changed: 7 additions & 0 deletions b/‎test/postgres.spec.js‎
Lines changed: 7 additions & 0 deletions
@@ -1490,6 +1490,33 @@ drop_stmt
         }
       };
     }
+  / a:KW_DROP __
+    r:KW_TYPE __
+    ife:if_exists? __
+    i:column_ref_list __
+    op:('CASCADE'i / 'RESTRICT'i)? {
+      /*
+      export interface drop_index_stmt_node {
+        type: 'drop';
+        prefix?: string;
+        keyword: string;
+        name: column_ref_list;
+        options?: 'cascade' | 'restrict';
+      }
+      => AstStatement<drop_index_stmt_node>
+      */
+      return {
+        tableList: Array.from(tableList),
+        columnList: columnListTableAlias(columnList),
+        ast: {
+          type: a.toLowerCase(),
+          keyword: r.toLowerCase(),
+          prefix: [ife].filter(v => v).join(' '),
+          name: i,
+          options: op && [{ type: 'origin', value: op }]
+        }
+      };
+    }
   / a:KW_DROP __
     r:KW_VIEW __
     ife:if_exists? __
@@ -5630,6 +5657,7 @@ KW_DUAL = "DUAL"i
 KW_ADD     = "ADD"i     !ident_start { return 'ADD'; }
 KW_COLUMN  = "COLUMN"i  !ident_start { return 'COLUMN'; }
 KW_INDEX   = "INDEX"i  !ident_start { return 'INDEX'; }
+KW_TYPE   = "TYPE"i  !ident_start { return 'TYPE'; }
 KW_KEY     = "KEY"i  !ident_start { return 'KEY'; }
 KW_FULLTEXT = "FULLTEXT"i  !ident_start { return 'FULLTEXT'; }
 KW_SPATIAL  = "SPATIAL"i  !ident_start { return 'SPATIAL'; }
 
@@ -33,6 +33,9 @@ function commonCmdToSQL(stmt) {
     case 'index':
       clauses.push(columnRefToSQL(name), ...stmt.table ? ['ON', tableToSQL(stmt.table)] : [], stmt.options && stmt.options.map(exprToSQL).filter(hasVal).join(' '))
       break
+    case 'type':
+      clauses.push(name.map(columnRefToSQL).join(', '), stmt.options && stmt.options.map(exprToSQL).filter(hasVal).join(' '))
+      break
     default:
       break
   }
 
@@ -2117,6 +2117,13 @@ describe('Postgres', () => {
           'CREATE TABLE "features" (feature_name TEXT NOT NULL COLLATE pg_catalog."default")'
         ]
       },
+      {
+        title: 'drop type stmt',
+        sql: [
+          'DROP TYPE IF EXISTS some_type, other_type CASCADE',
+          'DROP TYPE IF EXISTS some_type, other_type CASCADE'
+        ]
+      },
     ]
     neatlyNestTestedSQL(SQL_LIST)
   })
Original file line number	Diff line number	Diff line change
`@@ -2117,6 +2117,13 @@ describe('Postgres', () => {`
`2117`	`2117`	`'CREATE TABLE "features" (feature_name TEXT NOT NULL COLLATE pg_catalog."default")'`
`2118`	`2118`	`]`
`2119`	`2119`	`},`
	`2120`	`+ {`
	`2121`	`+ title: 'drop type stmt',`
	`2122`	`+ sql: [`
	`2123`	`+ 'DROP TYPE IF EXISTS some_type, other_type CASCADE',`
	`2124`	`+ 'DROP TYPE IF EXISTS some_type, other_type CASCADE'`
	`2125`	`+ ]`
	`2126`	`+ },`
`2120`	`2127`	`]`
`2121`	`2128`	`neatlyNestTestedSQL(SQL_LIST)`
`2122`	`2129`	`})`