We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent8dc7c33 commit57f2ff0Copy full SHA for 57f2ff0
src/bin/psql/tab-complete.c
@@ -1579,6 +1579,18 @@ psql_completion(const char *text, int start, int end)
1579
{
1580
/* complete with nothing here as this refers to remote publications */
1581
}
1582
+/* ALTER SUBSCRIPTION <name> SET PUBLICATION <name> */
1583
+elseif (HeadMatches3("ALTER","SUBSCRIPTION",MatchAny)&&
1584
+TailMatches3("SET","PUBLICATION",MatchAny))
1585
+{
1586
+COMPLETE_WITH_CONST("WITH (");
1587
+}
1588
+/* ALTER SUBSCRIPTION <name> SET PUBLICATION <name> WITH ( */
1589
1590
+TailMatches5("SET","PUBLICATION",MatchAny,"WITH","("))
1591
1592
+COMPLETE_WITH_LIST2("copy_data","refresh");
1593
1594
/* ALTER SCHEMA <name> */
1595
elseif (Matches3("ALTER","SCHEMA",MatchAny))
1596
COMPLETE_WITH_LIST2("OWNER TO","RENAME TO");