'drizzle-kit introspect:pg' generates invalid Typerscript syntax ("::character varying", "NULL")

When I use , it generates my schema.ts file, but includes syntax that is invalid, such as:

export const blogPosts = pgTable("blog_posts", {
    id: serial("id").primaryKey().notNull(),
    status: varchar("status", { length: 255 }).default('draft'::character varying).notNull(),
        ...

export const blogPosts = pgTable("blog_posts", {
    id: serial("id").primaryKey().notNull(),
    status: varchar("status", { length: 255 }).default('draft'::character varying).notNull(),
        ...

Note the

::character varying

::character varying

. This file does not work when using

push:pg

push:pg

due to these characters. I also noticed

.default(NULL)

.default(NULL)

which is also not valid. Can I prevent this?

Drizzle Team•2y ago

CLAYTONGP

'drizzle-kit introspect:pg' generates invalid Typerscript syntax ("::character varying", "NULL")

When I use , it generates my schema.ts file, but includes syntax that is invalid, such as:

export const blogPosts = pgTable("blog_posts", {
    id: serial("id").primaryKey().notNull(),
    status: varchar("status", { length: 255 }).default('draft'::character varying).notNull(),
        ...

export const blogPosts = pgTable("blog_posts", {
    id: serial("id").primaryKey().notNull(),
    status: varchar("status", { length: 255 }).default('draft'::character varying).notNull(),
        ...

Note the

::character varying

::character varying

. This file does not work when using

push:pg

push:pg

due to these characters. I also noticed

.default(NULL)

.default(NULL)

which is also not valid. Can I prevent this?

'drizzle-kit introspect:pg' generates invalid Typerscript syntax ("::character varying", "NULL")

Similar Threads

'drizzle-kit introspect:pg' generates invalid Typerscript syntax ("::character varying", "NULL")

Similar Threads

Similar Threads

Similar Threads