Optional PostgreSQL support for Netezza SQL Tools (justybase).
This extension adds a PostgreSQL dialect to Netezza SQL Tools (justybase) and integrates with the shared connection UI, schema browser, SQL execution flow, and dialect registry.
Requirements
Install the core extension first: Netezza SQL Tools (justybase)
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
First-class PostgreSQL SQL authoring profile for shared completion/diagnostics
DDL generation for tables, views, routines, and sequences in the connected database
PostgreSQL COPY import flow for CSV/XLSX/XLSB ingestion
EXPLAIN (FORMAT JSON) parsing and shared tuning-advisor scaffolding
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 explain command normalizes PostgreSQL JSON plans into the shared explain viewer.
Tuning advice is heuristic and currently focuses on scans, join shape, planner cost, and row-estimate drift.
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
