Postgres Schemas

Masonite ORM supports setting the schema on different classes to change which Postgres schema is called on different actions such as queries and migrations.

Setting schemas currently only works for the Postgres driver

Models

On model calls you can set the schema which will pass to the query builder:

User.set_schema("schema2").where(..).get()

Migrations

The migration command will take a --schema option to change the schema to run the migrations for. This option is available on all the migration commands.

If using Masonite you will use the python craft command instead of the masonite-orm command.

$ masonite-orm migrate --schema schema2

Connection Settings

On the postgres connection settings you can set the schema on the schema key:

"postgres": {
    "driver": "postgres",
    "host": "...",
    "user": "..",
    "password": "...",
    "schema": "schema2"
},

This will set the default schema for the postgres connection