Vscode-sqltools: Allow user to disable auto formatting `formatOnSave` and `formatOnPaste`

[abenhamdine]

Issue Type

• [ ] Bug
• [x] Enhancement
• [ ] Feature Request
• [ ] Question
• [ ] Other

Prerequisites (For bugfixes)

• [ ] Are you running the latest version?
• [ ] Did you check the logs?
• [ ] Did you check the Setup?

Description

Thx for this useful extension.
Anyway, it would be great to be able to disable automatic formatting, because my formatting rules are quite different.

Versions

• Version: v0.15.1
• OS: ...
• SGDB: PostgresSQL...

[mtxr]

Hey @abenhamdine, actually auto formatting is a VSCode feature, not SQLTools.

Could you please check if you have formatOnSave and formatOnParte active in you vscode settings?

[abenhamdine]

Could you please check if you have formatOnSave and formatOnParte active in you vscode settings?

Indeed yes, but autoformatting has never been applied on .sql files in vscode for me (and it was fine for us because we have our own sql style rules). it's just after have installed your extension that the autoformatting began to apply to .sql files.

[mtxr]

Right, it's formatting because SQLTools register as a format tool.

I'll add this option, but it will be enabled by default since you are the first that noticed that, ok?

Thanks @abenhamdine

[abenhamdine]

agree. Thanks to you @mtxr !

[mtxr]

@abenhamdine you can achieve this by settings option formatLanguages to [].

Try it and let me know. It's better than having a option to complete disable the formatting.

Currently there is no way in vscode to disable just auto format via extension api. So for now, I'll keep it like this to avoid bigger issues, ok?

Let me know if this solves your problem.

Thanks.

[joaoponceleao]

Hi,
This doesn't seem to be working. The only way I can disable formatting for sql files is by disabling the extension....