MajorAmari Posts - Answer Overflow

MajorAmari

Explore posts from servers

•Created by MajorAmari on 9/19/2023 in #help

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'

8 replies