pgsql extension

This extension is fixed clone of postgresql by JPTarquino

Features:

• Run current file into Postgres via psql
• Colorization
• Completion Lists for global postgres functions (copied from the Postgres official documentation)
• Snippets

Fixes

• use connection string with port and password
• add stderr output ( thanks for khushboo shah )
• shorter command

The extension recognizes the .sql,.ddl,.dml,.pgsql extension as sql files intended to be run in Postgres.

Using

To run the current sql file through psql (Postgres native client) you must add the following settings to your workspace:

{ "pgsql.connection": "postgres://username:password@host:port/database" }

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 "pgsql: run in postgres"