dbsql query buffer
The query buffer provides a mechanism to create multi-line SQL statements on the dbsql command line interpreter.
The dbsql command is line-oriented, but you can use the query buffer to edit
complex, multiline, SQL statements. You can edit, show, and reset the contents of the query buffer,
and write the contents of the buffer to a file.
- \e
- Edit the current query buffer or file with an external editor.
When you exit the editor, the system automatically runs your query. The query buffer stores only the last SQL statement. The default editor is vi. To change to another editor, set the EDITOR environment variable. For example, export EDITOR=emacs. This option is supported only on UNIX clients.
- \p
- Show the contents of the query buffer.
- \r
- Reset (clear) the query buffer.
- \w <file>
- Write the query buffer to a file.