Navigate to sql position

Question

IntelliJ pro comes with an embedded SQL editor.

Sometimes, I type a wrong request and the database returns an error and the corresponding SQL position.

Example :

[2017-01-02 16:32:35] [42P01] ERROR: missing FROM-clause entry for table "customer" Position : 516

Problem : for readability reasons, the request is written on multiple lines, making it harder to find the position 516.

Up to now, the only solution I got is to delete the \n characters in order to have the request on only one line then navigate to the 516th column.

But I guess there is a better way, like a fancy keyboard shortcut?

Answer 1

It's been a while you asked but I'll answer anyway to help others:

• Download "Character Position" plug-in from here:

  https://plugins.jetbrains.com/plugin/10334-character-position

• Install plugin & Restart IntelliJ

Character position will be shown in the bottom-left corner of the editor.