Drizzle Team•4mo ago

relation 'users' does not exist

After I've successfully generated the migration file, I do bun run ./migrate.ts then I do npx drizzle-kit studio but I get error relation 'users' does not exist.

2 Replies

⚡Z.E.U.S⚡•4mo ago

@JDaDev Hey! Can you share your drizzle.config.ts?

JDaDev•4mo ago

@⚡Z.E.U.S⚡ Hello:, here it is:

import { defineConfig } from "drizzle-kit"

export default defineConfig({
    schema: "./db/schema.ts",
    out: "./db/migrations",
    driver: "pg",
    dbCredentials: {
        database: process.env.DATABASE_NAME as string,
        host: process.env.DATABASE_HOST as string,
        port: process.env.DATABASE_PORT as any,
        user: process.env.DATABASE_USER as string,
        password: process.env.DATABASE_PASSWORD as string
    },
    verbose: true,
    strict: true,
})

import { defineConfig } from "drizzle-kit"

export default defineConfig({
    schema: "./db/schema.ts",
    out: "./db/migrations",
    driver: "pg",
    dbCredentials: {
        database: process.env.DATABASE_NAME as string,
        host: process.env.DATABASE_HOST as string,
        port: process.env.DATABASE_PORT as any,
        user: process.env.DATABASE_USER as string,
        password: process.env.DATABASE_PASSWORD as string
    },
    verbose: true,
    strict: true,
})

Gaming

Programming

relation 'users' does not exist