New major features:
- Enabled autocomplete for
\commands (including files for\i, DSNs for\c, fields for\pset) and context-based completion forSELECT,UPDATE,INSERT,DELETEqueries and variables - Added a
\copycommand to copy data between different databases (local files are not supported yet) - Added a
\crosstabcommand - Added a
\Gexec command that outputs in a vertical format (alamysql) - Added a
\watchcommand PAGERsupport- Added
\oand\qechocommands to send output to files or pipe to other system commands - Added the optional
FILEargument to\gand\gxto send their output to a file or pipe to other system commands; the commands also support passing formatting options - Support the
unaligned,tuples_only,htmlandasciidocoutput formats - Context propagation and cancellation (
CTRL+C) for in-flight queries
New Database Support:
Other fixes/improvements:
- Added a
-Gfor vertical output (see\Gabove) - Added a
-qflag and associatedQUIETenvironment variable to enable quiet output - Implement the
autooption for the\xcommand - Fixed issues with escaped and other special characters when
\set-ting variables - The
\begintransaction command now supports all of Go's transaction isolation levels, and read-only support \dupdated to print relations, foreign keys, and other constraints for tables- The
\d*commands now provide more information and work better with some databases; they also do a better job of hiding system objects by default \dcommand support for the Snowflake database- Now sets the
ROW_COUNTvariable for DML queries - Fixes table titles
Notes:
- CONTRIBUTING.md has been updated with details on implementing
\d*/ autocomplete for other databases