microsoft / microsoft/vscode-pgsql

[Feature] Support psql commands in the editor

Open
#29 0 comments 3 reactions 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

Copilot generates useful examples of how to achieve things in psql. But the editor doesn't support this command. As a Postgres extension it would be great if I can just run all of the psql commands right from the editor.

Examples:

  • Create database in one script.
create database foo;
\c foo
create table bar ();
  • Show details of the table in short hand!
\d+ mytable
  • Load data
\copy my_table(column1, column2, column3) FROM '/path/to/your/file.csv' DELIMITER ',' CSV HEADER;

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

No files, tests, or entry points are named. Start by locating the editor's PostgreSQL command execution path and determine how psql commands are currently handled. Done means the listed database creation, table-detail, and data-loading examples run successfully from the editor.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
database
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.