NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commitbd40951

committed

Minimal psql tab completion support for SET search_path.

Complete SET search_path = ... to non-temporary and non-toastschemas. Since there pretty much is no use case to add those to thesearch path and there can be many it's helpful to exclude them.It'd be nicer to complete multiple search path elements, but that'snot easy.Jeff Janes

1 parent626bfad commitbd40951Copy full SHA for bd40951

File tree

1 file changed

-0

lines changed

src/bin/psql
- tab-complete.c

1 file changed

-0

lines changed

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

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -3352,6 +3352,13 @@ psql_completion(const char *text, int start, int end)`
`3352`	`3352`
`3353`	`3353`	`COMPLETE_WITH_LIST(my_list);`
`3354`	`3354`	`}`
	`3355`	`+elseif (pg_strcasecmp(prev2_wd,"search_path")==0)`
	`3356`	`+{`
	`3357`	`+COMPLETE_WITH_QUERY(Query_for_list_of_schemas`
	`3358`	`+" AND nspname not like 'pg\\_toast%%' "`
	`3359`	`+" AND nspname not like 'pg\\_temp%%' "`
	`3360`	`+" UNION SELECT 'DEFAULT' ");`
	`3361`	`+}`
`3355`	`3362`	`else`
`3356`	`3363`	`{`
`3357`	`3364`	`staticconstchar*constmy_list[]=`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitbd40951

File tree

1 file changed

1 file changed

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

0 commit comments