Haydz
DTDrizzle Team
•Created by Haydz on 9/4/2024 in #help
error: relation "X" does not exist
I think i've got it working? I changed my db.ts file to use the connectionString instead of passing in host/port/.. etc.
connectionString does have ?schema=public at the end as well, so maybe try that 🤷♂️
import { drizzle } from 'drizzle-orm/node-postgres';
import { Client } from 'pg';
import * as schema from './schema';
export const client = new Client({
connectionString: process.env.DATABASE_URL!,
// host: process.env.DB_HOST!,
// port: Number(process.env.DB_PORT!),
// user: process.env.DB_USERNAME!,
// password: process.env.DB_PASSWORD!,
// database: process.env.DB_NAME!,
});
export const db = drizzle(client, { schema });
3 replies
