v1.0.0 Summary Chapter 2: Modeling basics 2. Start modeling 2.4. Code completion widget

2.4. Code completion widget

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.

Feb 20, 2023 at 18:17