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. 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 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
Make persistent, this way only hitting
Esc causes the widget to be closed. Any other action like double-click or hit
Enter will not trigger in 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.