Set up Drizzle with Existing Database with Multiple PostgreSQL Schemas

[VicSmithVercel]

How do you set up drizzle schema to use multiple postgreSQL database schemas?

Is there some property we put on each table like in Prisma or do we make multiple database connections with search_path being different for each schema?

[nicholasdly]

You can use the pgSchema method to define multiple schemas in PostgreSQL, and define tables within these schemas:

import { serial, text, pgTable, pgSchema } from "drizzle-orm/pg-core";

export const mySchema = pgSchema("my_schema");

export const colors = mySchema.enum('colors', ['red', 'green', 'blue']);

export const mySchemaUsers = mySchema.table('users', {
  id: serial('id').primaryKey(),
  name: text('name'),
  color: colors('color').default('red'),
});

Source: https://orm.drizzle.team/docs/schemas