@@ -2971,21 +2971,27 @@ psql_completion(const char *text, int start, int end)
29712971
29722972/* CREATE PUBLICATION */
29732973else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ))
2974- COMPLETE_WITH ("FOR TABLE" ,"FOR ALL TABLES" ,"FOR ALL TABLES IN SCHEMA" ,"WITH (" );
2974+ COMPLETE_WITH ("FOR TABLE" ,"FOR ALL TABLES" ,"FOR ALL TABLES IN SCHEMA" ,
2975+ "FOR SEQUENCE" ,"FOR ALL SEQUENCES" ,"FOR ALL SEQUENCES IN SCHEMA" ,
2976+ "WITH (" );
29752977else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ))
2976- COMPLETE_WITH ("TABLE" ,"ALL TABLES" ,"ALL TABLES IN SCHEMA" );
2978+ COMPLETE_WITH ("TABLE" ,"ALL TABLES" ,"ALL TABLES IN SCHEMA" ,
2979+ "SEQUENCE" ,"ALL SEQUENCES" ,"ALL SEQUENCES IN SCHEMA" );
29772980else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"ALL" ))
2978- COMPLETE_WITH ("TABLES" ,"TABLES IN SCHEMA" );
2979- else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"ALL" ,"TABLES" ))
2981+ COMPLETE_WITH ("TABLES" ,"TABLES IN SCHEMA" , "SEQUENCES" , "SEQUENCES IN SCHEMA" );
2982+ else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"ALL" ,"TABLES|SEQUENCES " ))
29802983COMPLETE_WITH ("IN SCHEMA" ,"WITH (" );
2981- else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"TABLE" ,MatchAny )&& !ends_with (prev_wd ,',' ))
2984+ else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"TABLE|SEQUENCE " ,MatchAny )&& !ends_with (prev_wd ,',' ))
29822985COMPLETE_WITH ("WHERE (" ,"WITH (" );
29832986/* Complete "CREATE PUBLICATION <name> FOR TABLE" with "<table>, ..." */
29842987else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"TABLE" ))
29852988COMPLETE_WITH_SCHEMA_QUERY (Query_for_list_of_tables );
2989+ /* Complete "CREATE PUBLICATION <name> FOR SEQUENCE" with "<sequence>, ..." */
2990+ else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"SEQUENCE" ))
2991+ COMPLETE_WITH_SCHEMA_QUERY (Query_for_list_of_sequences );
29862992
29872993/*
2988- * "CREATE PUBLICATION <name> FOR TABLE <name> WHERE (" - complete with
2994+ * "CREATE PUBLICATION <name> FOR TABLE|SEQUENCE <name> WHERE (" - complete with
29892995 * table attributes
29902996 */
29912997else if (HeadMatches ("CREATE" ,"PUBLICATION" ,MatchAny )&& TailMatches ("WHERE" ))
@@ -2996,14 +3002,14 @@ psql_completion(const char *text, int start, int end)
29963002COMPLETE_WITH (" WITH (" );
29973003
29983004/*
2999- * Complete "CREATE PUBLICATION <name> FOR ALL TABLES IN SCHEMA <schema>,
3005+ * Complete "CREATE PUBLICATION <name> FOR ALL TABLES|SEQUENCES IN SCHEMA <schema>,
30003006 * ..."
30013007 */
3002- else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"ALL" ,"TABLES" ,"IN" ,"SCHEMA" ))
3008+ else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"ALL" ,"TABLES|SEQUENCES " ,"IN" ,"SCHEMA" ))
30033009COMPLETE_WITH_QUERY_PLUS (Query_for_list_of_schemas
30043010" AND nspname NOT LIKE E'pg\\\\_%%'" ,
30053011"CURRENT_SCHEMA" );
3006- else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"ALL" ,"TABLES" ,"IN" ,"SCHEMA" ,MatchAny )&& (!ends_with (prev_wd ,',' )))
3012+ else if (Matches ("CREATE" ,"PUBLICATION" ,MatchAny ,"FOR" ,"ALL" ,"TABLES|SEQUENCES " ,"IN" ,"SCHEMA" ,MatchAny )&& (!ends_with (prev_wd ,',' )))
30073013COMPLETE_WITH ("WITH (" );
30083014/* Complete "CREATE PUBLICATION <name> [...] WITH" */
30093015else if (HeadMatches ("CREATE" ,"PUBLICATION" )&& TailMatches ("WITH" ,"(" ))