SQL Generator to File Ignores Formatting

Answered

Not sure if this is a bug or I am missing a configuration.

If I setup SQL Generator to export a PostgreSql schema file per object, the formatting within the files does not match what is displayed in the preview window.

If I leave 'Reformat generated code' unchecked, the preview window shows unformatted sql.

With 'Reformat generated code' checked the preview display formatting as expected:

 

However, in both cases, "Save to file" generates text files with no formatting.

How can I generate the DDL to file and preserve formatting?

4 comments
Comment actions Permalink

SQL Prompt not only will format your code exactly as you want, but will also help you switch quickly to an alternative style, or to apply exceptions to certain parts of a SQL script, where your preferred style isn't what's required.

 

MyBalanceNow

0
Avatar
Yuriy Vinogradov
Comment actions Permalink

looks similar to this issue https://youtrack.jetbrains.com/issue/DBE-5878 

please fill up bug report on our tracker.

0
Comment actions Permalink

DBE-5878 is somewhat related but no. This is not about reformatting in the editor. This is strictly about how 'Generate DDL to File' output does not apply formatting to the output nor correspond to what is shown in preview window where formatting is correctly applied.

Will try to submit a bug when I get time outside my work hours.

0
Comment actions Permalink

 This is not about reformatting in the editor. This is strictly about how 'Generate DDL to File' output does not apply formatting to the output.

0

Please sign in to leave a comment.