Skip to content

README.md

Latest commit

 

History

History
39 lines (26 loc) · 1.1 KB

README.md

File metadata and controls

39 lines (26 loc) · 1.1 KB

PostgreSQL Tree Viewer

PG Tree Viewer

Run

git clone git@github.com:evanchaoli/pgtreeviewer.git
cd pgtreeviewer
python3 server.py

Then open http://127.0.0.1:8765.

Features

  • Parse PostgreSQL node dump text (e.g. {QUERY ...}) into an expandable tree.
  • Resolve OID-like fields from a PostgreSQL database and annotate the tree.
  • Supported lookup kinds include relation OIDs, operator OIDs, function OIDs, type OIDs, collation OIDs, and namespace OIDs.

Connection Inputs

None of these fields are mandatory. If all are left empty, the resolver uses libpq defaults and connects to your local PostgreSQL instance. In practice, you usually need to provide the correct database name, because many OIDs (for example relation OIDs) are database-local.

Use the page inputs to set:

  • Host
  • Port
  • Database
  • User
  • Password
  • Application name

The server uses psql with PGHOST, PGPORT, PGDATABASE, PGUSER, PGPASSWORD, and PGAPPNAME.

Notes

  • psql must be available in PATH for OID resolution.
  • Unknown OIDs remain unannotated.