microsoft / microsoft/vscode-pgsql

Display table columns and properties with keyboard shortcut

Open
#104 1 comment 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement
Dominant language
No language data
Stars
395
Forks
33
Avg merge
1h 46m
Merged PRs (30d)
3

Description

The SQLTools extension coupled with the PostgreSQL driver has a keyboard shortcut of "cmd+e;cmd+d" that opens the command palette with a drop-down of all the tables in the active database. From there, select the table, and the window in the editor shows all of the columns and their properties in the table. Please do something similar. It can open PostgreSQL in the sidebar and expand the selected table instead of a new window in the editor. Just anything besides having to use the mouse to click through multiple nodes in the tree in the display the table and columns.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by investigating the SQLTools extension and PostgreSQL driver behavior described in the issue, then locate the PostgreSQL sidebar's table-tree and command handling. Define the keyboard flow and how the selected table should be expanded; done means a shortcut can select a table and reveal its columns and properties without repeated mouse navigation.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.