Reference

This section contains reference information for all jsqsh:

Commands

Most jsqsh commands are preceded with a backslash (\), however a number of commands come with built-in aliases for convenience.

Command	Alias(s)	Description
\alias		Create a command alias
[[\buf-append	\buf_append]]
[[\buf-copy	\buf_copy]]
[[\buf-edit	\buf_edit]]	vi, emacs
[[\buf-load	\buf_load]]	:r
\call		Call a prepared statement
\connect		Establishes a connection to a database
\create		Generates a CREATE TABLE using table definitions
\databases	\dbs	Displays list of available databases (catalogs)
\describe		Displays a description of a database object
\drivers		Displays a list of JDBC drivers known by jsqsh
\end		End the current session
\go	go	Executes the contents of the current buffer
\echo		Displays a line of text
\eval	:e	Read and execute an input file full of SQL
\help		Displays help information
\history		Displays a history of SQL statements executed
\insert		Generates INSERT statements from a query result
\macro		Creates a velocimacro from the current buffer
\procs		Displays stored procedures
\quit	quit	Exits jsqsh
\reset		Clears the current SQL buffer of its contents
\select		Generates a SELECT using table definitions<
\session		Displays set of sessions or switches to another session
\set		Sets a variable or displays all variables
\show		Show various types of database metadata
\tables		Displays tables, views, synonyms, etc.
\tree		Displays a tree view of tables
\unset		Removes a jsqsh variable