# Waiting for PostgreSQL 19 - Add psql PROMPT variable for search\_path.

DevFeed: [Waiting for PostgreSQL 19 - Add psql PROMPT variable for search\_path.](<https://devfeed.tech/articles/waiting-for-postgresql-19-add-psql-prompt-variable-for-search-path-33667.md>)

Original publisher: [Read original article](<https://www.depesz.com/2025/10/29/waiting-for-postgresql-19-add-psql-prompt-variable-for-search_path/>)

Author: depesz

Published: 2025-10-29T11:59:17Z

Content type: release

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>)

Tags: [commit](<https://devfeed.tech/tags/commit.md>), [pg19](<https://devfeed.tech/tags/pg19.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [prompt](<https://devfeed.tech/tags/prompt.md>), [prompt1](<https://devfeed.tech/tags/prompt1.md>), [psql](<https://devfeed.tech/tags/psql.md>), [query](<https://devfeed.tech/tags/query.md>), [schema](<https://devfeed.tech/tags/schema.md>), [schemas](<https://devfeed.tech/tags/schemas.md>), [search-path](<https://devfeed.tech/tags/search-path.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [waiting](<https://devfeed.tech/tags/waiting.md>)

## AI overview

A PostgreSQL patch adds a psql PROMPT variable for displaying the current search_path. The %S substitution works when connected to Postgres 18 or newer, because search_path was first marked as GUC_REPORT in a prior commit.

## Source excerpt

On 28th of October 2025, Nathan Bossart committed patch: Add psql PROMPT variable for search_path. The new %S substitution shows the current value of search_path. Note that this only works when connected to Postgres v18 or newer, since search_path was first marked as GUC_REPORT in commit 28a1121fd9. On older versions that don't report search_path, ... Continue reading "Waiting for PostgreSQL 19 - Add psql PROMPT variable for search_path."