postgres.git / summary / log / commit / refs

commit    d16eb83aba2e0abdc809ecffd51cc00a1beab7b8
Author:   Michael Paquier <michael@paquier.xyz>
Date:     Fri Oct 13 05:19:07 2023 +0000
First released in: 17.0

    psql: Add completion support for AT [ LOCAL | TIME ZONE ]
    
    AT TIME ZONE is completed with a list of supported timezones, something
    not needed by AT LOCAL.
    
    Author: Dagfinn Ilmari Mannsåker
    Reviewed-by: Jim Jones
    Discussion: https://postgr.es/m/87jzyzsvgv.fsf@wibble.ilmari.org


 src/bin/psql/tab-complete.c | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c
index d30d719a1f8..eb4dfe80b50 100644
--- a/src/bin/psql/tab-complete.c
+++ b/src/bin/psql/tab-complete.c
@@ -4682,6 +4682,12 @@ psql_completion(const char *text, int start, int end)
 	else if (TailMatches("JOIN"))
 		COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_selectables);
 
+/* ... AT [ LOCAL | TIME ZONE ] ... */
+	else if (TailMatches("AT"))
+		COMPLETE_WITH("LOCAL", "TIME ZONE");
+	else if (TailMatches("AT", "TIME", "ZONE"))
+		COMPLETE_WITH_TIMEZONE_NAME();
+
 /* Backslash commands */
 /* TODO:  \dc \dd \dl */
 	else if (TailMatchesCS("\\?"))


[parent: 97957fdbaa42]