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
Was this page helpful?