[Bug] PostgreSQL - Import SQL faild when using custom type with double quotes

[ifrvn]

When setting a custom type with double quotes in create table, import this sql file, drawdb throws an error.

CREATE TYPE "Gender" AS ENUM ('F', 'M', 'U');

CREATE TABLE "User" (
    "id" SERIAL NOT NULL,
    "gender" "Gender" NOT NULL,

    CONSTRAINT "User_pkey" PRIMARY KEY ("id")
);

SyntaxError [Ln 5, Col 14]: Expected "--", "->", "->>", ".", "/*", "BIGINT", "BIGSERIAL", "BOOL", "BOOLEAN", "CHAR", "CHARACTER", "DATE", "DATETIME", "DECIMAL", "DOUBLE", "ENUM", "FLOAT", "GEOMETRY", "INT", "INTEGER", "INTERVAL", "JSON", "JSONB", "LONGTEXT", "MEDIUMTEXT", "NUMERIC", "OID", "REAL", "RECORD", "REGCLASS", "REGCOLLATION", "REGCONFIG", "REGDICTIONARY", "REGNAMESPACE", "REGOPER", "REGOPERATOR", "REGPROC", "REGPROCEDURE", "REGROLE", "REGTYPE", "SERIAL", "SMALLINT", "TEXT", "TIME", "TIMESTAMP", "TINYINT", "TINYTEXT", "UUID", "VARCHAR", "bytea", [ \t\n\r], or [A-Za-z_一-龥] but """ found.

If I remove double quotes from "gender" "Gender" NOT NULL,, it'll work.

[1ilit]

Submitted an issue for this https://github.com/taozhi8833998/node-sql-parser/issues/2045.

[sanki92]

@1ilit I've submitted PR #607 that fixes this issue. The solution preprocesses PostgreSQL SQL to handle quoted custom types during import. Tested with the example SQL from this issue - now imports successfully.