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: Jelte Fennema-Nio <postgres@jeltef.nl>

Cc: Lauri Siltanen <lauri.siltanen@gmail.com>, pgsql-hackers@postgresql.org

Date: 2025-06-10T11:36:53Z

Lists: pgsql-hackers

Attachments

v1-0001-Make-S-available-in-psql-PROMPTs-to-indicate-the-.patch (application/octet-stream)
v1-0002-Return-empty-string-if-search_path-not-found.patch (application/octet-stream)

On Tue, Jun 10, 2025 at 2:08 AM Jelte Fennema-Nio <postgres@jeltef.nl>
wrote:

> On Mon, 9 Jun 2025 at 17:54, Florents Tselai <florents.tselai@gmail.com>
> wrote:
> > Here’s a quick attempt that makes %S substitue for a search_path
> > Like
> >  \set PROMPT1 'user:%n search_path: %S'
>
> +   else
> +       return PQuser(pset.db);
>
> That seems like a copy paste error. If we don't have data for it, we
> should either use the empty string, or some string like "<unknown>".
>

Opted for an empty string


> Other than that, the patch looks good (but I haven't tested it yet).
>

Btw - I haven't worked on bin/psql code;
aren't these auto tested?

CF: https://commitfest.postgresql.org/patch/5808/