Unexpected identifier 'TABLE'

I used drizzle-kit generate:pg to generate this schema

CREATE TABLE IF NOT EXISTS users (
    user_id INT PRIMARY KEY,
    username VARCHAR(255),
    email VARCHAR(255)
);

CREATE TABLE IF NOT EXISTS users (
    user_id INT PRIMARY KEY,
    username VARCHAR(255),
    email VARCHAR(255)
);

I tried to use drizzle-kit push:pg but I get this error

CREATE TABLE IF NOT EXISTS "users" (
       ^^^^^

SyntaxError: Unexpected identifier 'TABLE'

CREATE TABLE IF NOT EXISTS "users" (
       ^^^^^

SyntaxError: Unexpected identifier 'TABLE'

6 Replies

MAST•15mo ago

I'm pretty sure drizzle-kit push doesn't use the generated migrations. It is similar to the prisma push command that syncs the database with your corrent schema without using migrations.

MajorAmariOP•15mo ago

That's what I'm trying to do but I get this error

MAST•15mo ago

Hmm, why is drizzle-kit push looking at the migration files. This is weird, I really don't know what's going on here. Have you tried running it with node to see if it's a bun problem?

MajorAmariOP•15mo ago

I tried npx

MAST•15mo ago

OK, then Might be a drizzle-kit bug then.

MajorAmariOP•15mo ago

I felt so

Gaming

Programming

Unexpected identifier 'TABLE'