how to define postgres schema (other than 'public') while setting up with drizzle-orm/node-postgres
I have this code :
import { integer, serial, text, pgTable } from 'drizzle-orm/pg-core';
export const users = pgTable('prod.users', {
id: serial('id').primaryKey(),
email: text('email'),
});
But getting error : relation "prod.users" does not exist
import { integer, serial, text, pgTable } from 'drizzle-orm/pg-core';
export const users = pgTable('prod.users', {
id: serial('id').primaryKey(),
email: text('email'),
});
But getting error : relation "prod.users" does not exist