In almost all input fields that accept a SQL expression, pgModeler implements a basic but handy code completion widget (as shown below). The purpose of this control is to enhance the speed of command typing since the user can have quick access to objects' names as well as SQL keywords, and in some specific cases, code snippets. In order to activate the widget just hit
Ctrl + Space or just type the dot (
.) character and the completion will pop up. The listing changes as the user types something. To hide the completion hit
Esc. In order to use one of the elements in the listing just select it using the arrow keys or the mouse and hit
Enter or double-click the item.
The user can avoid the behavior of automatically closing the completion widget when selecting items by checking the box
Always on top, this way only hitting
Esc causes the widget to be closed. Any other action like double-clicking or hitting
Enter will not trigger the close action.
It's important to note that while using the completion widget in the design view all objects in the current database model are displayed as well as SQL keywords and code snippets. Now, when using the completion in manage view to type SQL commands sent to a server only SQL keywords and code snippets are displayed.