@@ -899,7 +899,7 @@ static const pgsql_thing_t words_after_create[] = {
899
899
{"GROUP" ,Query_for_list_of_roles },
900
900
{"LANGUAGE" ,Query_for_list_of_languages },
901
901
{"INDEX" ,NULL ,& Query_for_list_of_indexes },
902
- {"MATERIALIZED VIEW" ,NULL ,NULL },
902
+ {"MATERIALIZED VIEW" ,NULL ,& Query_for_list_of_matviews },
903
903
{"OPERATOR" ,NULL ,NULL },/* Querying for this is probably not such a
904
904
* good idea. */
905
905
{"OWNED" ,NULL ,NULL ,THING_NO_CREATE },/* for DROP OWNED BY ... */
@@ -1264,7 +1264,8 @@ psql_completion(const char *text, int start, int end)
1264
1264
"DELETE FROM" ,"DISCARD" ,"DO" ,"DROP" ,"END" ,"EXECUTE" ,"EXPLAIN" ,
1265
1265
"FETCH" ,"GRANT" ,"IMPORT" ,"INSERT" ,"LISTEN" ,"LOAD" ,"LOCK" ,
1266
1266
"MOVE" ,"NOTIFY" ,"PREPARE" ,
1267
- "REASSIGN" ,"REFRESH" ,"REINDEX" ,"RELEASE" ,"RESET" ,"REVOKE" ,"ROLLBACK" ,
1267
+ "REASSIGN" ,"REFRESH MATERIALIZED VIEW" ,"REINDEX" ,"RELEASE" ,
1268
+ "RESET" ,"REVOKE" ,"ROLLBACK" ,
1268
1269
"SAVEPOINT" ,"SECURITY LABEL" ,"SELECT" ,"SET" ,"SHOW" ,"START" ,
1269
1270
"TABLE" ,"TRUNCATE" ,"UNLISTEN" ,"UPDATE" ,"VACUUM" ,"VALUES" ,"WITH" ,
1270
1271
NULL
@@ -2653,13 +2654,15 @@ psql_completion(const char *text, int start, int end)
2653
2654
else if (Matches4 ("REFRESH" ,"MATERIALIZED" ,"VIEW" ,MatchAny ))
2654
2655
COMPLETE_WITH_CONST ("WITH" );
2655
2656
else if (Matches5 ("REFRESH" ,"MATERIALIZED" ,"VIEW" ,"CONCURRENTLY" ,MatchAny ))
2656
- COMPLETE_WITH_CONST ("WITH DATA " );
2657
+ COMPLETE_WITH_CONST ("WITH" );
2657
2658
else if (Matches5 ("REFRESH" ,"MATERIALIZED" ,"VIEW" ,MatchAny ,"WITH" ))
2658
2659
COMPLETE_WITH_LIST2 ("NO DATA" ,"DATA" );
2659
2660
else if (Matches6 ("REFRESH" ,"MATERIALIZED" ,"VIEW" ,"CONCURRENTLY" ,MatchAny ,"WITH" ))
2660
- COMPLETE_WITH_CONST ( "DATA" );
2661
+ COMPLETE_WITH_LIST2 ( "NO DATA" , "DATA" );
2661
2662
else if (Matches6 ("REFRESH" ,"MATERIALIZED" ,"VIEW" ,MatchAny ,"WITH" ,"NO" ))
2662
2663
COMPLETE_WITH_CONST ("DATA" );
2664
+ else if (Matches7 ("REFRESH" ,"MATERIALIZED" ,"VIEW" ,"CONCURRENTLY" ,MatchAny ,"WITH" ,"NO" ))
2665
+ COMPLETE_WITH_CONST ("DATA" );
2663
2666
2664
2667
/* REINDEX */
2665
2668
else if (Matches1 ("REINDEX" ))