SQL (PostgreSQL)

PostgreSQL-focused syntax highlighting for Visual Studio Code.

This extension adds a dedicated SQL (PostgreSQL) language mode for PostgreSQL SQL files, including psql commands and PL/pgSQL blocks.

Features

• Syntax highlighting for PostgreSQL SQL.
• Highlighting for psql meta-commands and variables.
• Highlighting for PL/pgSQL blocks in dollar-quoted strings.
• Support for PostgreSQL-specific strings, casts, parameters, operators, types, and built-in functions.
• Basic editor support for comments, brackets, auto-closing pairs, and folding markers.

Supported Files

• .sql
• .psql
• .pgsql

If a file opens with a different language mode, choose SQL (PostgreSQL) from the VS Code language selector.

Trademark Notice

Postgres, PostgreSQL and the Slonik Logo are trademarks of the PostgreSQL Community Association of Canada. This extension is not affiliated with, endorsed by, or sponsored by the PostgreSQL project.

See the PostgreSQL Trademark Policy: https://www.postgresql.org/about/policies/trademarks/