This extension adds a PostgreSQL dialect to the JustyBaseLite core extension and integrates with the shared connection UI, schema browser, SQL execution flow, and dialect registry.
Requirements
Install the core extension first: JustyBaseLite - Netezza
VS Code Desktop
Network access to your PostgreSQL server
Install runtime dependencies in this package before packaging:
Set-Location extensions\postgresql
npm install
What This Extension Adds
PostgreSQL connection type in the shared login panel
pg-based pure JavaScript runtime for query execution and cancellation
PostgreSQL metadata queries for schemas, tables, views, sequences, functions, procedures, and column lookup
A lightweight PostgreSQL SQL authoring profile
Baseline DDL generation for tables, views, routines, and sequences in the connected database
Current Runtime Notes
Each connection is scoped to a single PostgreSQL database. To browse another database, create a separate saved connection for that database.
Schema browsing intentionally excludes PostgreSQL system schemas such as pg_catalog and information_schema.
The optional package exposes DDL features, but table maintenance, explain-plan integration, and import helpers remain disabled in this iteration.
Generic DROP SESSION <pid> compatibility is translated to pg_terminate_backend(pid) when permissions allow it.
Development
Set-Location extensions\postgresql
npm run check-types
npm run build
Packaging
Set-Location extensions\postgresql
npm install
npm run package
