Horton

Re: Feature: psql - display current search_path in prompt

Florents Tselai <florents.tselai@gmail.com>

View thread
From: Florents Tselai <florents.tselai@gmail.com>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Jim Jones <jim.jones@uni-muenster.de>, Jelte Fennema-Nio <postgres@jeltef.nl>, Lauri Siltanen <lauri.siltanen@gmail.com>, pgsql-hackers@postgresql.org
Date: 2025-10-24T14:10:13Z
Lists: pgsql-hackers

Attachments

On Thu, Oct 23, 2025 at 11:52 PM Nathan Bossart <nathandbossart@gmail.com>
wrote:

> On Thu, Jun 12, 2025 at 06:57:37PM +0300, Florents Tselai wrote:
> > Absent any other feedback I'm marking this as Ready for Committer;
> > Said committer can push back on my arbitrary %S selection
> > https://commitfest.postgresql.org/patch/5808/
>
> PQparameterStatus() will return NULL if the parameter is not known.  So,
> with this patch, using %S in a prompt when connected to a <v18 version of
> PostgreSQL will produce an empty string.  Given an empty string is a valid
> value for search_path, I think we probably want to use a special value in
> this case.  Perhaps we could use "?", which is much less likely to be a
> value for search_path.
>

Good catch. v2 attached