From a46b35dbc36df38d42c8b8538aeee724f47030d1 Mon Sep 17 00:00:00 2001 From: Bernd Helmle Date: Tue, 27 Aug 2013 00:10:34 +0200 Subject: [PATCH] Teach SET search_path TO to complete possible namespaces. --- src/bin/psql/tab-complete.c | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index b3de387b94..65d9610892 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -3121,6 +3121,10 @@ psql_completion(char *text, int start, int end) COMPLETE_WITH_LIST(my_list); } + else if (pg_strcasecmp(prev2_wd, "search_path") == 0) + { + COMPLETE_WITH_QUERY(Query_for_list_of_schemas); + } else { static const char *const my_list[] = -- 2.39.5