7 replies

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

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'