3 replies

multiple schema files

Hi im a bit confused on how to use multiple schemas. When i use mutiple files, db._.fullSchema retuns a emty object.
this is my drizzle config:

import "dotenv/config";
import { defineConfig } from "drizzle-kit";
export default defineConfig({
  out: "./server/drizzle",
  schema: "./server/db/schema",
  dialect: "postgresql",
  dbCredentials: {
    url: process.env.DATABASE_URL!,
  },
});

import "dotenv/config";
import { defineConfig } from "drizzle-kit";
export default defineConfig({
  out: "./server/drizzle",
  schema: "./server/db/schema",
  dialect: "postgresql",
  dbCredentials: {
    url: process.env.DATABASE_URL!,
  },
});

and this is how i init the db

import "dotenv/config";
import { drizzle } from "drizzle-orm/node-postgres";
export const db = drizzle(process.env.DATABASE_URL!);

import "dotenv/config";
import { drizzle } from "drizzle-orm/node-postgres";
export const db = drizzle(process.env.DATABASE_URL!);

See image for file struct.

Can anyone tell me what im doing wrong?

Drizzle Team•14mo ago•

3 replies

TheConsoleGardenMG

multiple schema files

Hi im a bit confused on how to use multiple schemas. When i use mutiple files, db._.fullSchema retuns a emty object.
this is my drizzle config:

import "dotenv/config";
import { defineConfig } from "drizzle-kit";
export default defineConfig({
  out: "./server/drizzle",
  schema: "./server/db/schema",
  dialect: "postgresql",
  dbCredentials: {
    url: process.env.DATABASE_URL!,
  },
});

import "dotenv/config";
import { defineConfig } from "drizzle-kit";
export default defineConfig({
  out: "./server/drizzle",
  schema: "./server/db/schema",
  dialect: "postgresql",
  dbCredentials: {
    url: process.env.DATABASE_URL!,
  },
});

and this is how i init the db

import "dotenv/config";
import { drizzle } from "drizzle-orm/node-postgres";
export const db = drizzle(process.env.DATABASE_URL!);

import "dotenv/config";
import { drizzle } from "drizzle-orm/node-postgres";
export const db = drizzle(process.env.DATABASE_URL!);

See image for file struct.

Can anyone tell me what im doing wrong?

multiple schema files

Similar Threads

multiple schema files

Similar Threads

Similar Threads

Similar Threads