- type/table/view/function/procedure name completion.
- go to the type/table/view/function/procedure definition.
- hover type/table/view/function/procedure definition.
- syntax check.
- static analysis check (when plpgsql_check use) .
- Multi-root Workspace support.
- Set your database connection to VSCode settings.
- Open
.pgsql
file and edit your code!
{
"plpgsqlLanguageServer.database": "your_database_name",
"plpgsqlLanguageServer.user": "your_database_user",
"plpgsqlLanguageServer.password": "your_database_password",
"plpgsqlLanguageServer.definitionFiles": [
// Support glob.
"**/*.sql",
"**/*.psql",
"**/*.pgsql"
],
// The supported extention types are ['*.pgsql', '*.psql'].
// If you want to use this extension in '*.sql', add the following settings.
"files.associations": {
"*.sql": "postgres"
}
}
If you want to disable the extension for a specific file, just add this comment your file top.
/* plpgsql-language-server:disable */
Or, if you want to disable only the validation feature, try this
/* plpgsql-language-server:disable validation */