On Thu, Nov 02, 2023 at 07:27:02PM +0300, Gilles Darold wrote:
> Look like the tab completion for CREATE TABLE ... AS is not
> proposed.
>
> +     /* Complete CREATE TABLE <name> AS with list of keywords */
> +     else if (TailMatches("CREATE", "TABLE", MatchAny, "AS") ||
> +                      TailMatches("CREATE", "TEMP|TEMPORARY|UNLOGGED", 
> "TABLE", MatchAny, "AS"))
> +             COMPLETE_WITH("SELECT", "WITH");

There is a bit more than SELECT and WITH as possible query for a CTAS.
How about VALUES, TABLE or even EXECUTE (itself able to handle a
SELECT, TABLE or VALUES)?
--
Michael

Attachment: signature.asc
Description: PGP signature

Reply via email to