From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
---|---|
To: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
Cc: | pgsql-general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Would it be possible to add functions to tab-completion in psql? |
Date: | 2022-08-16 13:55:34 |
Message-ID: | 20220816135534.ppgkyfn3emn3hbwm@jrouhaud |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
On Tue, Aug 16, 2022 at 02:28:49PM +0200, hubert depesz lubaczewski wrote:
> Hi,
> As a dba I have to, very often, query system functions, starting with
> pg_last_xact_replay_timestamp and pg_current_wal_lsn.
>
> Would it be possible/hard/expensive, to change tab-completion so that:
>
> select pg_<tab> would work?
That specific example may be easy to do, but others like e.g.
SELECT pg_size_pretty(pg_rel<TAB>
SELECT pg_last_xact_replay_timestamp(), pg_current_w<TAB>
wouldn't.
You can refer to [1] and [2] threads for more background, but the limitations
that prevented anything from being committed until now still exist so I'm not
really hoping for anything new on that side :( I usually have another psql
running somewhere, where I can run \df and similar, and copy/paste stuff
around. That's not great, but still better than trying to remember the exact
spelling of all useful functions.
[1] https://www.postgresql.org/message-id/flat/CAMyN-kB_xrU4iYdcF1j%3DtijgO1DSyjtb3j96O4UEj91XZrZcMg%40mail.gmail.com
[2] https://www.postgresql.org/message-id/flat/1328820579.11241.4.camel%40vanquo.pezone.net
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2022-08-16 13:59:12 | Re: Would it be possible to add functions to tab-completion in psql? |
Previous Message | Ron | 2022-08-16 13:51:49 | Re: Would it be possible to add functions to tab-completion in psql? |