PostgreSQL
Connect to PostgreSQL databases, inspect schemas, and run queries from Athas.
On this page3 sections
PostgreSQL support is available through the PostgreSQL database provider.
Connect to PostgreSQL
Install the PostgreSQL provider from Settings > Extensions, then use Database: Connect to Database from the command palette or create a saved connection in Settings > Database.
The default PostgreSQL port is 5432.
What You Can Do
- Browse schemas, tables, and views
- Inspect columns, indexes, and foreign keys where available
- Filter and search table data
- Run SQL queries
- Edit rows and cells where supported
- Copy or export result data when available
Notes
PostgreSQL connections are saved connections. They are managed from Settings > Database rather than opened from local files.