2022-11-23 16:37:30 +08:00
|
|
|
---
|
2022-12-27 10:19:57 +08:00
|
|
|
title: TablePlus
|
2022-11-23 16:37:30 +08:00
|
|
|
date: 2022-11-23 16:23:31.706905
|
2022-12-22 11:39:35 +08:00
|
|
|
background: bg-[#ecc550]
|
2024-05-22 03:37:57 -07:00
|
|
|
label:
|
|
|
|
|
tags:
|
|
|
|
|
-
|
|
|
|
|
-
|
2022-11-23 16:37:30 +08:00
|
|
|
categories:
|
2024-05-22 03:37:57 -07:00
|
|
|
- Keyboard Shortcuts
|
2022-11-23 16:37:30 +08:00
|
|
|
intro: |
|
2024-05-22 03:37:57 -07:00
|
|
|
A visual cheat-sheet for the 34 keyboard shortcuts found in TablePlus
|
2022-11-23 16:37:30 +08:00
|
|
|
---
|
|
|
|
|
|
2024-05-22 03:37:57 -07:00
|
|
|
## Keyboard Shortcuts
|
2022-11-23 16:37:30 +08:00
|
|
|
|
|
|
|
|
### Global
|
|
|
|
|
|
2024-05-22 03:37:57 -07:00
|
|
|
| Shortcut | Action |
|
|
|
|
|
| ------------------ | --------------------- |
|
|
|
|
|
| `Ctrl` `N` | Open a new connection |
|
|
|
|
|
| `Ctrl` `Q` | Quit app |
|
|
|
|
|
| `Ctrl` `Shift` `O` | Open SQL file |
|
|
|
|
|
| `Ctrl` `,` | Open Preferences |
|
2022-11-23 16:37:30 +08:00
|
|
|
|
2024-05-22 03:37:57 -07:00
|
|
|
{.shortcuts}
|
2022-11-23 16:37:30 +08:00
|
|
|
|
|
|
|
|
### Workspace
|
|
|
|
|
|
2024-05-22 03:37:57 -07:00
|
|
|
| Shortcut | Action |
|
|
|
|
|
| ---------------------- | ------------------------------ |
|
|
|
|
|
| `Ctrl` `W` | Close a tab/window |
|
|
|
|
|
| `Ctrl` `S` | Commit the changes |
|
|
|
|
|
| `Ctrl` `T` | Open a new tab |
|
|
|
|
|
| `Ctrl` `L` | Open plugin manager |
|
|
|
|
|
| `Ctrl` `.` | Run custom script |
|
|
|
|
|
| `Ctrl` `R` | Reload workspace |
|
|
|
|
|
| `Ctrl` `[` | Navigate to left tab |
|
|
|
|
|
| `Ctrl` `]` | Navigate to right tab |
|
|
|
|
|
| `Ctrl` `Shift` `[` | Navigate to left Pane |
|
|
|
|
|
| `Ctrl` `Shift` `]` | Navigate to right Pane |
|
|
|
|
|
| `Ctrl` `D` | Split Pane horizontally |
|
|
|
|
|
| `Ctrl` `1-9` | Navigate to number tab |
|
|
|
|
|
| `Ctrl` `K` | Switch database |
|
|
|
|
|
| `Ctrl` `Shift` `K` | Switch connection |
|
|
|
|
|
| `Ctrl` `I` | Indent selected SQL Code |
|
|
|
|
|
| `Ctrl` `E` | Execute SQL Code |
|
|
|
|
|
| `Ctrl` `O` | Open file SQL |
|
|
|
|
|
| `Ctrl` `Shift` `Enter` | Uglify selected SQL statements |
|
|
|
|
|
| `Ctrl` `\` | Comment/Uncomment lines of SQL |
|
|
|
|
|
| `Ctrl` `Z` | Undo |
|
|
|
|
|
| `Ctrl` `Shift` `Z` | Redo |
|
|
|
|
|
| `Ctrl` `P` | Open anything |
|
|
|
|
|
| `Ctrl` `E` | Open SQL Query |
|
|
|
|
|
| `Ctrl` `(click)` | Open item in new tab |
|
|
|
|
|
| `Tab` | Move focus while editing |
|
2022-11-23 16:37:30 +08:00
|
|
|
|
2024-05-22 03:37:57 -07:00
|
|
|
{.shortcuts}
|
2022-11-23 16:37:30 +08:00
|
|
|
|
|
|
|
|
### Table Data
|
|
|
|
|
|
2024-05-22 03:37:57 -07:00
|
|
|
| Shortcut | Action |
|
|
|
|
|
| ---------------- | ----------------------------------- |
|
|
|
|
|
| `Space` | Toggle row detail when row selected |
|
|
|
|
|
| `Ctrl` `C` | Copy rows |
|
|
|
|
|
| `Ctrl` `V` | Paste rows |
|
|
|
|
|
| `Ctrl` `Alt` `I` | Insert a new row |
|
|
|
|
|
| `Tab` | Move focus while editing |
|
2022-11-23 16:37:30 +08:00
|
|
|
|
2024-05-22 03:37:57 -07:00
|
|
|
{.shortcuts}
|
2022-11-23 16:37:30 +08:00
|
|
|
|
2024-05-22 03:37:57 -07:00
|
|
|
## Also see
|
2022-11-23 16:37:30 +08:00
|
|
|
|
|
|
|
|
- [Keyboard shortcuts for TablePlus app](https://tableplus.com/blog/2018/02/shortcut-keys.html) _(tableplus.com)_
|