Drizzle TeamDT
Drizzle Team•3y ago
Pipriles

Use a different schema on postgres

Hello, I am currently trying to define a table with drizzle like this:

const rollupAccountResponsesDaily = pgTable('rollup_account_responses_daily', {
  rollupDate: timestamp('rollup_date', { withTimezone: true }),
  accountId: uuid('account_id'),
  questionId: text('question_id'),
  source: text('source'),
  msa: text('msa'),
  response: text('response'),
  metrics: jsonb('metrics'),
  createdAt: timestamp('created_at', { withTimezone: true }),
  updatedAt: timestamp('updated_at', { withTimezone: true }),
});


But this table is not on the public schema on postgres, is there a way to change the schema so that the generated code will be "sandbox.rollup_account_responses_daily" ?

Thanks
Was this page helpful?