Feedback
3.3
Session SettingsΒΆ
This section documents settings that only apply to the currently connected client session. Currently, there is only one of these settings.
See also
Settings can be changed during a session with SET and RESET.
search_path
: schema names (default:doc
)The list of schemas that will be used to look for a relation that is referenced without a schema.
CrateDB will try to resolve an unqualified relation name against the configured
search path
by iterating over the configured schemas in the order they were declared in. The first matching relation in thesearch path
is used, or an error is reported if there is no match.In order to configure the
search path
we useSET search_path TO myschema, doc;
The current search path value could be retrieved using SHOW (session settings):
SHOW search_path;
This setting mirrors the PostgreSQL search_path setting.
Some clients, which generally connect to CrateDB using the PostgreSQL wire protocol, require access to various tables in the pg_catalog schema, usually to extract information about built-in data types or functions. CrateDB implements the system pg_catalog schema and it implicitly includes it in the
search_path
before the configured schemas, unless it is explicitly declared in thesearch_path
on any position.