On Sat, 7 Jun 2025 at 20:52, Lauri Siltanen <lauri.silta...@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
