Unexpected identifier 'TABLE'

I used

drizzle-kit generate:pg

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)
);

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

 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'

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

SyntaxError: Unexpected identifier 'TABLE'

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

SyntaxError: Unexpected identifier 'TABLE'

MAST•9/19/23, 3:36 AM

I'm pretty sure

drizzle-kit push

drizzle-kit push

doesn't use the generated migrations.

It is similar to the prisma

push

push

command that syncs the database with your corrent schema without using migrations.

MajorAmariOP•9/19/23, 3:38 AM

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

MAST•9/19/23, 3:40 AM

Hmm, why is drizzle-kit push looking at the migration files.

This is weird, I really don't know what's going on here.

MAST•9/19/23, 3:41 AM

Have you tried running it with node to see if it's a bun problem?

MajorAmariOP•9/19/23, 3:41 AM

I tried npx

MAST•9/19/23, 3:42 AM

OK, then

Might be a drizzle-kit bug then.

MajorAmariOP•9/19/23, 3:42 AM

I felt so