Formating INSERT statement in DataGrip

Answered

Is it possible to automatically align INSERT statement code using code formatting in DataGrip.

I would like INSERT INTO Table (Col1, Col2) VALUES ('a', 1), ('bb', 22), ('ccccc', 33333);

would be formated into 

INSERT INTO Table

               (Col1,    Col2)

VALUES ('a',        1)

             , ('bb',      22)

             , ('ccccc', 33333);

1
3 comments

You can configure many parameters in Preferences/Settings | Editor | Code Style | SQL | General | Queries.

Pay attention to INSERT statement and VALUES clause options.

0

Unfortunately I can't make it.

I want to have insert values as table:

 

0

Gotcha. Please follow DBE-13187.

0

Please sign in to leave a comment.