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. Standard Mac OS shortcuts are not included to keep the list manageable This page describes most keyboard commands supported by Postico. For more information on how to write and run queries, please read the running queries guide.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 Now that you’ve connected with Query Service, you can use Postico to write queries. See the official Postico documentation for more information on using the query view. A table appears with the results of your completed query run. When finished, select Execute Statement to run the query. Alternatively, use the keyboard shortcut (⇧⌘T) to navigate to the query view and enter the query you want to execute. To create a new SQL query, select SQL Query from the sidebar. To find your credentials, log in to Platform, then select Queries, followed by Credentials.Īfter inserting your credentials, select Connect to connect with Query Service.Īfter connecting to Platform, you’ll be able to see a list of all the relations previously made with Query Service. Use your Experience Platform Database credential value: prod:all.įor more information on finding your database name, host, port, and login credentials, please read the credentials guide. The configuration JSON file for non-expiring credentials is a one-time download during their initialization that Adobe does not keep a copy of. If you want to use non-expiring credentials, this value is the concatenated arguments from the technicalAccountID and the credential downloaded in the configuration JSON file. This alphanumeric string is your Experience Platform Password credential. Leave the field blank to use your Mac login name. You must use port 80 or 5432 to connect with Query Service.Ĭreate a name for your specific connection. Instructions on how to connect to a PostgreSQL server with Postico are also available from the official Postico website. Enter the connection settings listed below. From here, you can enter parameter values to connect with Adobe Experience Platform. The dialog for connection settings appears. To connect Postico to Query Service, open Postico and select New Favorite. More information about Postico can be found in the official Postico documentation.Īdditionally, Postico is only available on macOS devices. This guide assumes you already have access to Postico and are familiar with how to navigate its interface.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |