Commitd0f2f53

committed

psql: Add tab completion for COPY with query

From: Andreas Karlsson <andreas@proxel.se>

1 parent422a55a commitd0f2f53Copy full SHA for d0f2f53

File tree

+10

-3

lines changed

+10

-3

lines changed

Lines changed: 10 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1934,11 +1934,18 @@ psql_completion(const char *text, int start, int end)`
`1934`	`1934`	`/* COPY */`
`1935`	`1935`
`1936`	`1936`	`/*`
`1937`		`- * If we have COPY [BINARY] (which you'd have to type yourself), offer`
`1938`		`- *list of tables (Also cover the analogousbackslash command)`
	`1937`	`+ * If we have COPY, offer list of tables or "(" (Also cover the analogous`
	`1938`	`+ * backslash command).`
`1939`	`1939`	`*/`
`1940`		`-elseif (Matches1("COPY\|\\copy")\|\|Matches2("COPY","BINARY"))`
	`1940`	`+elseif (Matches1("COPY\|\\copy"))`
	`1941`	`+COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_tables,`
	`1942`	`+" UNION ALL SELECT '('");`
	`1943`	`+/* If we have COPY BINARY, complete with list of tables */`
	`1944`	`+elseif (Matches2("COPY","BINARY"))`
`1941`	`1945`	`COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_tables,NULL);`
	`1946`	`+/* If we have COPY (, complete it with legal commands */`
	`1947`	`+elseif (Matches2("COPY\|\\copy","("))`
	`1948`	`+COMPLETE_WITH_LIST7("SELECT","TABLE","VALUES","INSERT","UPDATE","DELETE","WITH");`
`1942`	`1949`	`/* If we have COPY [BINARY] <sth>, complete it with "TO" or "FROM" */`
`1943`	`1950`	`elseif (Matches2("COPY\|\\copy",MatchAny)\|\|`
`1944`	`1951`	`Matches3("COPY","BINARY",MatchAny))`

Comments

(0)