From f7b38a4a6027fd516efdd976a312a100a9a4e1e5 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 6 May 2018 09:02:02 -0400 Subject: [PATCH] - add a tl;dr to postgresql search_path section as it's long and will be easier to read if we know where it's going first. Change-Id: I2766cf4655451ed514d4dc95ac60406b9f4a8ddb (cherry picked from commit 513a6e5bcea5dccabaf86166906233542a4669e7) --- lib/sqlalchemy/dialects/postgresql/base.py | 3 +++ 1 file changed, 3 insertions(+) diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index 0160239b75..c9270943b7 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -125,6 +125,9 @@ Valid values for ``isolation_level`` include: Remote-Schema Table Introspection and PostgreSQL search_path ------------------------------------------------------------ +**TL;DR;**: keep the ``search_path`` variable set to its default of ``public``, +name schemas **other** than ``public`` explicitly within ``Table`` defintitions. + The PostgreSQL dialect can reflect tables from any schema. The :paramref:`.Table.schema` argument, or alternatively the :paramref:`.MetaData.reflect.schema` argument determines which schema will -- 2.47.2