On Thu, 6 Feb 2025 at 16:29, Umar Hayat <postgresql.wizard@gmail.com> wrote:
>
> Hi,
> Recently the ONLY option is introduced [1] for VACUUM and ANALYZE
> commands. Attach provides improved tab completion for this new option
> for both commands.
>
> Along with this also added starting parenthesis "(" auto-complete as
> multiple existing commands provide it and it makes it easier to
> separate command options (VERBOSE, FREEZE, ... ) from table list.
This will include "ONLY" also when we display the tables too:
+ else if (HeadMatches("ANALYZE"))
+
COMPLETE_WITH_SCHEMA_QUERY_PLUS(Query_for_list_of_analyzables,
"ONLY");
like below:
postgres=# analyze only t1
information_schema. ONLY public. t1
The same issue exists with vacuum too:
postgres=# vacuum only t1
information_schema. ONLY public. t1
Regards,
Vignesh