[BUG]: Incorrect Schema Generated when introspecting extisting pg database

[sirjager]

What version of drizzle-orm are you using?

0.30.0

What version of drizzle-kit are you using?

0.20.14

Describe the Bug

Context

I am using neon's PostgreSQL db, which is connected to my Directus instance.
I want to query directly from db using drizzle, so that i don't have to deploy Directus,
Currently i am running Directus locally on docker with neon db.

What i have done

1. Generated schema from existing db using drizzle-kit introspect:pg

Error

In the generated schema and SQL file

Default value is causing error

--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "directus_roles" (
	"id" uuid PRIMARY KEY NOT NULL,
	"name" varchar(100) NOT NULL,
	"icon" varchar(30) DEFAULT 'supervised_user_circle'::character varying NOT NULL,
	"description" text,
	"ip_access" text,
	"enforce_tfa" boolean DEFAULT false NOT NULL,
	"admin_access" boolean DEFAULT false NOT NULL,
	"app_access" boolean DEFAULT true NOT NULL
);

Parsing error: ',' expected. 22:71:70 eslint_d
',' expected. 22:72:70 typescript1005

export const directusRoles = pgTable("directus_roles", {
	id: uuid("id").primaryKey().notNull(),
	name: varchar("name", { length: 100 }).notNull(),
	icon: varchar("icon", { length: 30 }).default('supervised_user_circle'::character varying).notNull(),
	description: text("description"),
	ipAccess: text("ip_access"),
	enforceTfa: boolean("enforce_tfa").default(false).notNull(),
	adminAccess: boolean("admin_access").default(false).notNull(),
	appAccess: boolean("app_access").default(true).notNull(),
});

I have around 50 tables now, and schema will be changing as the app grows
and this issue is almost in every table.
And Every time i generate schema it generates wrong code.

Expected behavior

No response

Environment & setup

linux 6.7.8.arch1-1
Hyprland
EndeavourOS

[raikusy]

I am facing same issue. Is the any fix?

I am using drizzle-kit introspect command.
drizzle-orm v0.30.10
drizzle-kit v0.21.4

Currently I am having to search and remove all ::character varying manually from schema.ts file.

[AndriiSherman]

This should be fixed in [email protected]
If you still encounter this issue, please reopen the ticket