Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commita87ae38

Browse files
committed
Add tab completion for ALTER TABLESPACE MOVE in psql.
1 parent5ff47ac commita87ae38

File tree

1 file changed

+26
-4
lines changed

1 file changed

+26
-4
lines changed

‎src/bin/psql/tab-complete.c

Lines changed: 26 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1622,12 +1622,12 @@ psql_completion(char *text, int start, int end)
16221622
COMPLETE_WITH_CONST("IDENTITY");
16231623
}
16241624

1625-
/* ALTER TABLESPACE <foo> with RENAME TO, OWNER TO, SET, RESET */
1625+
/* ALTER TABLESPACE <foo> with RENAME TO, OWNER TO, SET, RESET, MOVE */
16261626
elseif (pg_strcasecmp(prev3_wd,"ALTER")==0&&
16271627
pg_strcasecmp(prev2_wd,"TABLESPACE")==0)
16281628
{
16291629
staticconstchar*constlist_ALTERTSPC[]=
1630-
{"RENAME TO","OWNER TO","SET","RESET",NULL};
1630+
{"RENAME TO","OWNER TO","SET","RESET","MOVE",NULL};
16311631

16321632
COMPLETE_WITH_LIST(list_ALTERTSPC);
16331633
}
@@ -1649,6 +1649,27 @@ psql_completion(char *text, int start, int end)
16491649

16501650
COMPLETE_WITH_LIST(list_TABLESPACEOPTIONS);
16511651
}
1652+
/* ALTER TABLESPACE <foo> MOVE ALL|TABLES|INDEXES|MATERIALIZED VIEWS */
1653+
elseif (pg_strcasecmp(prev4_wd,"ALTER")==0&&
1654+
pg_strcasecmp(prev3_wd,"TABLESPACE")==0&&
1655+
pg_strcasecmp(prev_wd,"MOVE")==0)
1656+
{
1657+
staticconstchar*constlist_TABLESPACEMOVETARGETS[]=
1658+
{"ALL","TABLES","INDEXES","MATERIALIZED VIEWS",NULL};
1659+
1660+
COMPLETE_WITH_LIST(list_TABLESPACEMOVETARGETS);
1661+
}
1662+
elseif ((pg_strcasecmp(prev4_wd,"TABLESPACE")==0&&
1663+
pg_strcasecmp(prev2_wd,"MOVE")==0)||
1664+
(pg_strcasecmp(prev5_wd,"TABLESPACE")==0&&
1665+
pg_strcasecmp(prev3_wd,"MOVE")==0&&
1666+
pg_strcasecmp(prev2_wd,"MATERIALIZED")==0))
1667+
{
1668+
staticconstchar*constlist_TABLESPACEMOVEOPTIONS[]=
1669+
{"OWNED BY","TO",NULL};
1670+
1671+
COMPLETE_WITH_LIST(list_TABLESPACEMOVEOPTIONS);
1672+
}
16521673

16531674
/* ALTER TEXT SEARCH */
16541675
elseif (pg_strcasecmp(prev3_wd,"ALTER")==0&&
@@ -2559,8 +2580,9 @@ psql_completion(char *text, int start, int end)
25592580
* but we may as well tab-complete both: perhaps some users prefer one
25602581
* variant or the other.
25612582
*/
2562-
elseif (pg_strcasecmp(prev3_wd,"FETCH")==0||
2563-
pg_strcasecmp(prev3_wd,"MOVE")==0)
2583+
elseif ((pg_strcasecmp(prev3_wd,"FETCH")==0||
2584+
pg_strcasecmp(prev3_wd,"MOVE")==0)&&
2585+
pg_strcasecmp(prev_wd,"TO")!=0)
25642586
{
25652587
staticconstchar*constlist_FROMIN[]=
25662588
{"FROM","IN",NULL};

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp