DT
Drizzle Teamsivaraman
error: no schema has been selected to create in while running push command
trying to setup drizzle with local postgres database, DB_CONN_STRING is 'postgres://postgres:password@localhost:5432/test?schema=public'
drizzle config:
import 'dotenv/config';
import type { Config } from 'drizzle-kit';
export default {
schema: './src/core/schema.ts',
out: './drizzle',
driver: 'pg', // 'pg' | 'mysql2' | 'better-sqlite' | 'libsql' | 'turso'
verbose: true,
schemaFilter: ['public'],
dbCredentials: {
connectionString: process.env.DB_CONN_STRING,
},
} satisfies Config;
error:
error: no schema has been selected to create in
at /Users/apple/Projects/me/korero-server/node_modules/drizzle-kit/bin.cjs:24462:21
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async PgPostgres.query (/Users/apple/Projects/me/korero-server/node_modules/drizzle-kit/bin.cjs:25423:21)
at async Command.<anonymous> (/Users/apple/Projects/me/korero-server/node_modules/drizzle-kit/bin.cjs:63261:9) {
length: 120,
severity: 'ERROR',
code: '3F000',
detail: undefined,
hint: undefined,
position: '28',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'namespace.c',
line: '499',
routine: 'RangeVarGetCreationNamespace'
thanks in advance
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
7.3KMembers
View on DiscordWant results from more Discord servers?
More PostsNavigating through multiple many-to-many relationships in a single query?Hi all! I've been racking my brain unsuccessfuly on how to accomplish my desired behavior with a queCircular Reference Error when Using Self-Reference in Table Definition with Drizzle-ORMI encountered an error while defining a PostgreSQL table using Drizzle-ORM. The issue arises when at