Server Configuration: Client Connection Defaults
18.11. Client Connection Defaults
18.11.1. Statement Behavior
-
search_path
(string
) -
This variable specifies the order in which schemas are searched when an object (table, data type, function, etc.) is referenced by a simple name with no schema specified. When there are objects of identical names in different schemas, the one found first in the search path is used. An object that is not in any of the schemas in the search path can only be referenced by specifying its containing schema with a qualified (dotted) name.
The value for
search_path
must be a comma-separated list of schema names. Any name that is not an existing schema, or is a schema for which the user does not haveUSA