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
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
