mirror of
https://github.com/stancl/tenancy-docs.git
synced 2025-12-12 10:14:03 +00:00
15 lines
658 B
Markdown
15 lines
658 B
Markdown
---
|
|
title: PostgreSQL schema separation
|
|
description: PostgreSQL schema separation
|
|
extends: _layouts.documentation
|
|
section: content
|
|
---
|
|
|
|
# PostgreSQL schema separation {#postgresql-schema-separation}
|
|
|
|
If you're using PostgreSQL, you can separate tenant databases by *schemas* instead of *databases*.
|
|
|
|
To enable this, set the config like this:
|
|
|
|
- `tenancy.database.separate_by`: `'schema'` to tell the package how we're separating databases
|
|
- `tenancy.database_managers.pgsql`: `Stancl\Tenancy\TenantDatabaseManagers\PostgreSQLSchemaManager::class` to tell the package to use the schema creator/deleter instead of database creator/deleter for pgsql databases.
|