Disable schema validation

[kishankishore2908]

Is there a way I can sqlc wherein I do not have to have the CREATE SCHEMA statement in my migration ?

[danthegoodman1]

You shouldn't need to, works for me without one.

[danthegoodman1]

version: 1
packages:
  - path: "crdb"
    name: "crdb"
    engine: "postgresql"
    schema: "schema.sql"
    queries: "./queries/"
    sql_package: "pgx/v4"

[kishankishore2908]

So in schema.sql you don't have a CREATE SCHEMA statement defined and you are using the schema in your query files ?

[danthegoodman1]

Nope, just have some create table and index statements.

[danthegoodman1]

Maybe make sure you are running the latest version?

[ftjfo]

I can confirm that I had to write "create schema" today, with a very similar setup