postgres.git / summary / log / commit / refs

commit    6d4ca6de97770cdaee18517dd2f8fe8f4ecee187
Author:   Fujii Masao <fujii@postgresql.org>
Date:     Fri Jul 03 04:46:35 2026 +0000
First released in: 14.24, 15.19, 16.15, 17.11, 18.6

    psql: Fix \df tab completion for procedures
    
    Commit fb421231daa extended \df to include procedures, but its tab
    completion continued not to show procedures.
    
    Update \df tab completion to include procedures as well.
    
    Backpatch to all supported versions.
    
    Author: Erik Wienhold <ewie@ewie.name>
    Reviewed-by: Surya Poondla <suryapoondla4@gmail.com>
    Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
    Discussion: https://postgr.es/m/10fbfdfe-80f6-4ef9-b8b3-f7be0eb53a50@ewie.name
    Backpatch-through: 14


 src/bin/psql/tab-complete.in.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/bin/psql/tab-complete.in.c b/src/bin/psql/tab-complete.in.c
index e4722c06664..e4bc2c93145 100644
--- a/src/bin/psql/tab-complete.in.c
+++ b/src/bin/psql/tab-complete.in.c
@@ -5655,7 +5655,7 @@ match_previous_words(int pattern_id,
 	else if (TailMatchesCS("\\dew*"))
 		COMPLETE_WITH_QUERY(Query_for_list_of_fdws);
 	else if (TailMatchesCS("\\df*"))
-		COMPLETE_WITH_VERSIONED_SCHEMA_QUERY(Query_for_list_of_functions);
+		COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_routines);
 	else if (HeadMatchesCS("\\df*"))
 		COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_datatypes);