1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
+----------------+----------+---------------------------------+-------------------------------------------------------------+
| Command | Shortcut | Usage | Description |
+----------------+----------+---------------------------------+-------------------------------------------------------------+
| \G | <null> | <query>\G | Display query results vertically. |
| \bug | <null> | \bug | File a bug on GitHub. |
| \clip | <null> | <query>\clip | Copy query to the system clipboard. |
| \dt | <null> | \dt[+] [table] | List or describe tables. |
| \edit | \e | <query>\edit | \edit <filename> | Edit query with editor (uses $VISUAL or $EDITOR). |
| \f | <null> | \f [name [args..]] | List or execute favorite queries. |
| \fd | <null> | \fd <name> | Delete a favorite query. |
| \fs | <null> | \fs <name> <query> | Save a favorite query. |
| \l | <null> | \l | List databases. |
| \llm | \ai | \llm [arguments] | Interrogate an LLM. See "\llm help". |
| \once | \o | \once [-o] <filename> | Append next result to an output file (overwrite using -o). |
| \pipe_once | \| | \pipe_once <command> | Send next result to a subprocess. |
| \timing | \t | \timing | Toggle timing of queries. |
| connect | \r | connect [database] | Reconnect to the server, optionally switching databases. |
| delimiter | <null> | delimiter <string> | Change end-of-statement delimiter. |
| exit | \q | exit | Exit. |
| help | \? | help [term] | Show this help, or search for a term on the server. |
| nopager | \n | nopager | Disable pager; print to stdout. |
| notee | <null> | notee | Stop writing results to an output file. |
| nowarnings | \w | nowarnings | Disable automatic warnings display. |
| pager | \P | pager [command] | Set pager to [command]. Print query results via pager. |
| prompt | \R | prompt <string> | Change prompt format. |
| quit | \q | quit | Quit. |
| redirectformat | \Tr | redirectformat <format> | Change the table format used to output redirected results. |
| rehash | \# | rehash | Refresh auto-completions. |
| source | \. | source <filename> | Execute queries from a file. |
| status | \s | status | Get status information from the server. |
| system | <null> | system [-r] <command> | Execute a system shell command (raw mode with -r). |
| tableformat | \T | tableformat <format> | Change the table format used to output interactive results. |
| tee | <null> | tee [-o] <filename> | Append all results to an output file (overwrite using -o). |
| use | \u | use <database> | Change to a new database. |
| warnings | \W | warnings | Enable automatic warnings display. |
| watch | <null> | watch [seconds] [-c] <query> | Execute query every [seconds] seconds (5 by default). |
+----------------+----------+---------------------------------+-------------------------------------------------------------+
|
