Fix some issues and improve psql completion for access methods

Michael Paquier <michael@paquier.xyz>

Commit: 0240a00fbd4fd14f577edf8d36a032237fd0b9cb
Author: Michael Paquier <michael@paquier.xyz>
Date: 2019-06-03T02:02:32Z
Releases: 12.0
Fix some issues and improve psql completion for access methods

The following issues have been spotted:
- CREATE INDEX .. USING suggests both index and table AMs, but it should
consider only index AMs.
- CREATE TABLE .. USING has no completion support.  USING was not being
included in the completion list where it should, and follow-up
suggestions for table AMs have been missing as well.
- CREATE ACCESS METHOD .. TYPE suggests only INDEX, with TABLE missing.

Author: Michael Paquier
Discussion: https://postgr.es/m/20190601191007.GC1905@paquier.xyz

Files

PathChange+/−
src/bin/psql/tab-complete.c modified +20 −3

Discussion