Function SearchPath

core/context.go:264–285

SearchPath returns the effective schema search path for the current session

(ctx *sql.Context)

// SearchPath returns the effective schema search path for the current session
func SearchPath(ctx *sql.Context) ([]string, error) {
	path, err := resolve.SearchPath(ctx)
	if err != nil {
		return nil, err
	}

	// pg_catalog is *always* implicitly part of the search path as the first element, unless it's specifically
	// included later. This allows users to override built-in names with user-defined names, but they have to
	// opt in to that behavior.
	hasPgCatalog := false
	for _, schema := range path {
		if schema == "pg_catalog" {
			hasPgCatalog = true
			break
		}
	}

	if !hasPgCatalog {
		path = append([]string{"pg_catalog"}, path...)
	}
	return path, nil
}

// GetExtensionsCollectionFromContext returns the extensions collection from the given context. Will always return a
// collection if no error is returned.