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

Commitbe92207

Browse files
michaelpqpull[bot]
authored andcommitted
Add psql tab compression for ALTER TABLE .. { OF | NOT OF }
ALTER TABLE .. OF is now able to complete with the list of availablecomposite types that can be used with the query.Author: Aleksander AlekseevReviewed-by: Shinya KatoDiscussion:https://postgr.es/m/47b71e0c523b30357208e79786161281@oss.nttdata.com
1 parentba06acf commitbe92207

File tree

1 file changed

+6
-1
lines changed

1 file changed

+6
-1
lines changed

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

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2240,7 +2240,8 @@ psql_completion(const char *text, int start, int end)
22402240
"ENABLE","INHERIT","NO","RENAME","RESET",
22412241
"OWNER TO","SET","VALIDATE CONSTRAINT",
22422242
"REPLICA IDENTITY","ATTACH PARTITION",
2243-
"DETACH PARTITION","FORCE ROW LEVEL SECURITY");
2243+
"DETACH PARTITION","FORCE ROW LEVEL SECURITY",
2244+
"OF","NOT OF");
22442245
/* ALTER TABLE xxx ADD */
22452246
elseif (Matches("ALTER","TABLE",MatchAny,"ADD"))
22462247
{
@@ -2473,6 +2474,10 @@ psql_completion(const char *text, int start, int end)
24732474
elseif (Matches("ALTER","TABLE",MatchAny,"DETACH","PARTITION",MatchAny))
24742475
COMPLETE_WITH("CONCURRENTLY","FINALIZE");
24752476

2477+
/* ALTER TABLE <name> OF */
2478+
elseif (Matches("ALTER","TABLE",MatchAny,"OF"))
2479+
COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_composite_datatypes);
2480+
24762481
/* ALTER TABLESPACE <foo> with RENAME TO, OWNER TO, SET, RESET */
24772482
elseif (Matches("ALTER","TABLESPACE",MatchAny))
24782483
COMPLETE_WITH("RENAME TO","OWNER TO","SET","RESET");

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp