Re: Feature: psql - display current search_path in prompt

From: Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>
To: Lauri Siltanen <lauri(dot)siltanen(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Feature: psql - display current search_path in prompt
Date: 2025-06-07 23:36:54
Message-ID: CAGECzQR1-U9=q0dXvUX9aO2zA9O5qt-m2k0PmOrhwTNMdTRiOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, 7 Jun 2025 at 20:52, Lauri Siltanen <lauri(dot)siltanen(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2025-06-08 01:17:06 Re: [PATCH] Re: Proposal to Enable/Disable Index using ALTER INDEX
Previous Message Pavel Stehule 2025-06-07 17:11:16 Re: proposal: plpgsql, new check for extra_errors - strict_expr_check