Query buffer
Because the nzsql command is line-oriented,
it is difficult to edit a complex, multiline SQL statement. To make
it easier, use the query buffer.
- \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, not on Windows clients.
- \p
- Show the contents of the query buffer.
- \r
- Reset (clear) the query buffer.
- \w <file>
- Write the query buffer to a file.