/vscode-pgsql

Visual Studio Code extension for Postgres

Primary LanguageJavaScriptOtherNOASSERTION

pgsql extension

This extension is fixed clone of postgresql by JPTarquino

Features:

  • Execute sql file into Postgres (Ctrl+F5) via psql
  • Colorization - converted from mulander
  • Completion lists for keywords - copied from the Postgres documentation
  • Few snippets ( Ctrl+Space, type 'pg' )

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

demo

Usage

  • Setup psql is in the OS executable path
  • Customize Postgress connection ( settings in workspace ):
{ "pgsql.connection": "postgres://username:password@host:port/database" }
  • Open file with pgsql type and run ( press Ctrl+F5 or Cmd+F5 on Mac )
  • For snippets press Ctrl+Space, type 'pg'