Online Documentation for SQL Manager for PostgreSQL

Keyboard Templates


The Keyboard Templates window allows you to create new keyboard templates for quicker typing regularly used expressions and to edit the existing ones.

 

To open this window, select the Options | iconKeyboardTemplate Keyboard Templates... main menu item.

 

menuKeyboardTemplates

 

To add a new keyboard template, click the Add Template... button, set the template name and define the template expression. In the upper right area of the window you can change the case of the template expression (As is, Uppercase, Lowercase, First upper).

 

You can deactivate an existing template by selecting it from the list on the left and removing the Active flag of the template.

 

Keyboard Templates

 

If necessary, you can also edit the template name using the Edit Template... button, delete the template using the Delete Template button or edit the template expression within the Expansion area of the window. For faster editing you can use the Cursor, Author, Time, Date, Clipboard, Marker buttons.

 

Hint: Add/edit/delete template items are also available in the context menu of the template list on the right.

 

CheckBox Old style

This option specifies whether the selected keyboard template expansion should conform to the template specifications used in the earlier versions of SQL Manager for PostgreSQL.

 

Once you have defined the templates, you can use them in Query Data. First of all, make sure that the CheckBox Auto launch keyboard templates option is selected on the Quick Code page of the Editor Options dialog. When editing SQL text in Query Data, type a template name and use the Ctrl+J shortcut: the text associated with the template (Expansion) will be inserted automatically.

 

Hint: The Reset to defaults button which is available at the bottom of the Keyboard Templates dialog allows you to discard all changes and restore the settings to their defaults.