Autocomplete

Multiple autocomplete suggestions can be present. You can cycle forwards through the suggestions by repeatedly pressing Tab, or Shift+Tab to cycle backwards. autocompletion can be reverted by pressing ESC twice.

The shell autocompletes four different groups:

Keywords
Table names and table functions
Column names and scalar functions
File names

The shell looks at the position in the SQL statement to determine which of these autocompletions to trigger. For example:

SELECT s

student_id

SELECT student_id F

FROM

SELECT student_id FROM g

grades

SELECT student_id FROM 'd

'data/

SELECT student_id FROM 'data/

'data/grades.csv

About this page