| 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
| 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 |