Use sql SCHEMA when working with tables

[vserge]

---

name: Feature request
about: Using SCHEMA when working with database tables
title: 'Using SCHEMA'
labels: 'SCHEMA'
assignees: ''

---

**When using SCHEMA when working with database tables **
When working with tables, in some cases it is necessary to use SCHEMA to separate the data in the database.

Possible solution
I suggest adding another parameter to the functions for working with tables, which will determine the schema name.

[essenciary]

@vserge can you please give more details?

[vserge]

Currently, SearchLight.jl places all tables and data in the public schema only. However, there is no way either in the configuration file or in calling migration methods to tell you to use a database schema other than public.

[vserge]

For example, i use different schemas for story different type of data