vscode-sql-formatter icon indicating copy to clipboard operation
vscode-sql-formatter copied to clipboard

SQL files formatting fails with error: `There is no formatter for 'plsql' files installed.'

Open olttwa opened this issue 5 years ago • 4 comments

VS Code version: 1.47.0

Configuration:

"sql-formatter.dialect": "pl/sql",
"sql-formatter.uppercase": true,
"sql-formatter.linesBetweenQueries": 2,

I've installed the sql-formatter package using npm before installing this extension.

Any help would be appreciated. Thanks.

olttwa avatar Jul 18 '20 15:07 olttwa

+1, Same problem(

dobraccoon avatar Aug 14 '20 07:08 dobraccoon

+1, Same problem

mlpiller avatar Sep 02 '20 15:09 mlpiller

bottom right hand corner in the status-bar, make sure you check that the correct language is being detected by vscode. You can click where it says plsql and change it to sql. You can also set this extension as the default formatter for plsql files in your settings.json as well.

g5becks avatar Sep 30 '20 17:09 g5becks

You can also set this extension as the default formatter for plsql files in your settings.json as well.

Did you try it ? I've set

"[plsql]": {
    "editor.defaultFormatter": "adpyke.vscode-sql-formatter"
  }

but I still get the message. If I've not done a blunder, could it be because the extension has the activation event: onLanguage:sql ?

masebu avatar May 28 '21 16:05 masebu