Use the command "Execute All Queries" in the "Connection" menu or ⌥⌘↩︎ to execute all statements at once. You can switch between results using a popup menu button at the bottom left. When you execute multiple statements, Postico will display the first result. They will be executed in an implicit transaction, so if one of the statements fails, all changes to the database will be rolled back. You can execute multiple statements at once by selecting them. The corresponding results are displayed below the text view. Use the command "Execute Query" in the "Connection" menu or press ⌘↩︎ to execute the current statement (or the current selection, if any). The query view highlights the current statement in light grey. There's also a keyboard shortcut (⇧⌘T) to navigate to the query view. You can get to the SQL Query View by clicking on "SQL Query" in the sidebar. Usually on the top left corner of the keyboard.You are looking at the documentation for Postico v1.3.5 - would you like to go to the latest version instead? Using the SQL Query ViewĬustom database queries can be executed from the SQL Query view in Postico. Labelled "ctrl" on modern Apple keyboards. Labelled "option" or "alt" on modern Apple keyboards. Sometimes called "Apple key" since it used to have an Apple logo on older keyboards. This is a list of keyboard symbols used above: ⌘ The Command key. (Return is not allowed on these alerts to avoid accidental deletions) Legend of Keyboard Symbols ⌘/ Comment or uncomment the selected line(s) by prepending two dashes ⌥⌘/ Comment (or uncomment) the selection with a block comment ( /* */) ^H Look up the current word (or selection) in Dash Alerts ↩ Confirm the default action esc Cancel the operation ⌘⌫ Use this shortcut to confirm when the alert asks you if you want to delete an object. ^⌘→ Replace the current query with the next query from your history. ⇥ Edit next field (move right) ⇧⇥ Edit previous field (move left) ↑ Edit field above (move up) ↓ Edit field below (move left) ↩ Commit changes to current field esc Abort editing and discard changes to current field ⌥⇥ Insert tab into field ⌥↩ Insert newline into field SQL Query View ⌘↩︎ Execute the current query (or the current selection, if any) ⌥⌘↩︎ Execute all queries in the Query View ⇧⌘T Go the SQL Query View (used to be called the Terminal) ⇥ Shift the selected line(s) to the right (increase indentation) ⇧⇥ Shift the selected line(s) to the left (decrease indentation) ⌘] Alternate shortcut for shift right ⌘[ Alternate shortcut for shift left ^⌘← Replace the current query with the previous query from your history. Table View ⌥⌘T Switch between table contents and structure ⇧⌘N Insert a new row ⌘D Duplicate selected row(s) ⌘S Save changes ⌥⌘F Show or hide the table filter bar. (That's a zero) ⌥⌘0 Show or hide the right sidebar. ⇧⌘F Filter the list of tables in the sidebar. Postico will reconnect to the server automatically as needed. This is sometimes the only way to abort an operation. Also, this command has no effect if the query has already completed but Postico is still busy downloading the results. Note that it can take some time until the command reaches the server, and the server might not cancel the query immediately. This command reloads the current view, the sidebar, and purges all cached views (except those with unsaved changes) ⌥⌘R Reload current view only. table → database → server) ⌥⌘↓ Navigate down in the hierarchy (open the currently selected item) ⌘R Reload. (when you want to make a new connection) ⌥⌘N Opens a new window for the current connection. General Navigation ⌘N Opens the favorite window. Go to Keyboard → Shortcuts → App Shortcuts and you can change the shortcuts for any app on your Mac. However, you can change any keyboard shortcut in System Preferences. Postico has no built-in feature to change keyboard shortcuts. The shortcuts should feel familiar to most people working on a Mac.
I've tried to follow platform conventions as much as possible when picking these keyboard shortcuts.
Some buttons also have shortcuts just hover over them and the tooltip will tell you. I mention this because people are increasingly ignoring the wonderful menu bar at the top of the screen. The easiest way to discover keyboard shortcuts is to browse through the application menus. I assume that you are familiar with them anyway.
#Postico run query mac os#
Standard Mac OS shortcuts are not included to keep the list manageable This page describes most keyboard commands supported by Postico. You are looking at the documentation for Postico v1.0.6 - would you like to go to the latest version instead? Keyboard Shortcuts in Postico
0 kommentar(er)
