PostgresSql for Visual Studio Code
This extension the following features when working with pgsql files in VS Code:
The extension recognizes the .pgsql extension as sql files intended to be run in Postgres.
Pre-requisites for executing a pgsql file
To run the current .pgsql file through pgsql (Postgres native client) you must add the following settings to your workspace:
You must also ensure that psql is in the OS executable path (it will be executed as simply "psql" from vscode).
The command to run the current file is "Postgres: Execute File in Server".