3 replies

Unable to create tables in custom schema

Next.js✅Solved

Here is how I have configured my Database connection with Supabase

database: new Pool({
    connectionString: process.env.DATABASE_URL,
    options: "-c search_path=better_auth"
  })

database: new Pool({
    connectionString: process.env.DATABASE_URL,
    options: "-c search_path=better_auth"
  })

I am using Direct Connection with Supabase
postgresql://postgres:[YOUR-PASSWORD]@db.[MY-PROJECT-ID].supabase.co:5432/postgres

Yet everytime i run the migration command

npx @better-auth/cli migrate --config lib/better-auth/auth.ts

npx @better-auth/cli migrate --config lib/better-auth/auth.ts

I end up with tables in public schema.

Am i missing something here?

Better Auth•4w ago•

3 replies

jainam

Unable to create tables in custom schema

Next.js✅Solved

Here is how I have configured my Database connection with Supabase

database: new Pool({
    connectionString: process.env.DATABASE_URL,
    options: "-c search_path=better_auth"
  })

database: new Pool({
    connectionString: process.env.DATABASE_URL,
    options: "-c search_path=better_auth"
  })

I am using Direct Connection with Supabase
postgresql://postgres:[YOUR-PASSWORD]@db.[MY-PROJECT-ID].supabase.co:5432/postgres

Yet everytime i run the migration command

npx @better-auth/cli migrate --config lib/better-auth/auth.ts

npx @better-auth/cli migrate --config lib/better-auth/auth.ts

I end up with tables in public schema.

Am i missing something here?

Unable to create tables in custom schema

Similar Threads

Unable to create tables in custom schema

Similar Threads

Similar Threads

Similar Threads