Smart Keys settings: SQL

Use this settings page to configure typing assistance features in SQL.

For more information about SQL support in RubyMine, refer to Database Tools and SQL.

Item	Description
Insert string concatenation on Enter	You may want to turn this option off, if the DBMS you are working with supports multiline string literals: Say, there is the following fragment for PostgreSQL `text` value `notes`: SET notes = 'Lightest element' and the caret is in front of the word `element`. If the option is on, and you press `Enter`, the fragment will change to: SET notes = 'Lightest ' \|\| 'element' Otherwise, the fragment will change to: SET notes = 'Lightest element'
Close code blocks on Enter	When you start a code block with an opening keyword (BEGIN, LOOP, BEGIN TRY, and others) and press `Enter`, the code block closes with the corresponding closing keywords (END, END LOOP, END TRY, and others).

Item

Description

Insert string concatenation on Enter

You may want to turn this option off, if the DBMS you are working with supports multiline string literals:

Say, there is the following fragment for PostgreSQL text value notes:

SET notes = 'Lightest element'

and the caret is in front of the word element.

If the option is on, and you press Enter, the fragment will change to:

                    SET notes = 'Lightest ' ||
                    'element'

Otherwise, the fragment will change to:

                    SET notes = 'Lightest
                    element'

Close code blocks on Enter

When you start a code block with an opening keyword (BEGIN, LOOP, BEGIN TRY, and others) and press Enter, the code block closes with the corresponding closing keywords (END, END LOOP, END TRY, and others).

23 June 2025