diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index d4b6976..3542855 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -1579,6 +1579,11 @@ psql_completion(const char *text, int start, int end) { /* complete with nothing here as this refers to remote publications */ } + /* ALTER SUBSCRIPTION SET PUBLICATION */ + else if (HeadMatches3("ALTER", "SUBSCRIPTION", MatchAny) && TailMatches3("SET", "PUBLICATION", MatchAny)) + { + COMPLETE_WITH_LIST2("REFRESH", "SKIP REFRESH"); + } /* ALTER SCHEMA */ else if (Matches3("ALTER", "SCHEMA", MatchAny)) COMPLETE_WITH_LIST2("OWNER TO", "RENAME TO");