Thread

Re: Feature: psql - display current search_path in prompt

Florents Tselai <florents.tselai@gmail.com> — 2025-06-09T15:54:16Z

> On 8 Jun 2025, at 2:36 AM, Jelte Fennema-Nio <postgres@jeltef.nl> wrote:
> 
> On Sat, 7 Jun 2025 at 20:52, Lauri Siltanen <lauri.siltanen@gmail.com> wrote:
>> I need to switch search_paths often. It would be tremendously helpful to see the current search_path in the prompt.
> 
> That feature should be pretty easy to implement, now that search_path
> is marked as GUC_REPORT in PG18. Basically you need to use
> PQparameterStatus like we do for session_authorization[1][2].
> 
> [1]: https://github.com/postgres/postgres/blob/73e26cbeb5927053eea4e209e5eda34a30c353f1/src/bin/psql/prompt.c#L166-L169
> [2]: https://github.com/postgres/postgres/blob/73e26cbeb5927053eea4e209e5eda34a30c353f1/src/bin/psql/common.c#L2508-L2520
> 
> 


Here’s a quick attempt that makes %S substitue for a search_path
Like
 \set PROMPT1 'user:%n search_path: %S'