How I can disable the creation of the schema

[phaalonso]

My database user don't have permissions to create an schema, and this is breaking the migrations on the first step CREATE SCHEMA IF NOT EXISTS "public". There is any way to disable this step?

It's a postgres database

(even after manually creating the tables, and inserting the migrations in the migrations table it's still breaking because it's tries to create the schema)

[phaalonso]

I commented this line on node_modules/drizzle-orm/pg-core/dialect.cjs to solve the problem

But it will be better if there is an check if the schema already exists to prevent problems with database users that don't have permissions to create schemas

[filipweilid]

Would also love a way to disable this. Resorted to patch the package to remove the line for now

[aindeev]

Would be great to disable this rather than having to patch the package.

[abettke]

+1 Would also love a way to disable this. This causes issues when trying to migrate during deploys to render.com since the user registered with the DB does not have permission to create schemas.

[DaliborHomola]

+1 also working with DB that has no permission to create schema

[JSEvgeny]

+1 to have a way to disable this with config. Our db creds don't have permission to create schema and we also create it manually before deploying new schema first time