Postgres Pro
Downloads
Home   >   mailing lists

Re: Feature: psql - display current search_path in prompt - Mailing list pgsql-hackers

From Jelte Fennema-Nio
Subject Re: Feature: psql - display current search_path in prompt
Date
Msg-id CAGECzQR1-U9=q0dXvUX9aO2zA9O5qt-m2k0PmOrhwTNMdTRiOg@mail.gmail.com
Whole thread Raw
In response to Feature: psql - display current search_path in prompt  (Lauri Siltanen <lauri.siltanen@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: plpgsql, new check for extra_errors - strict_expr_check
Next
From: David Rowley
Date:
Subject: Re: [PATCH] Re: Proposal to Enable/Disable Index using ALTER INDEX