Visitar URL original
Add a way to edit named queries from an external editor · Issue #1430 · dbcli/pgcli · GitHub
Skip to content

Add a way to edit named queries from an external editor #1430

Description

@radoslawklak

Description

I think it can be helpfull to have:

  1. An ability to edit named quieries in my \editor (f.ex. vim): with \n familly command - maybe \ne
  2. I would like to skip the named query show at the top when I'm running it - I want only the results - I have big queries and I need to scroll them every time. It can be via config vile parameter.

Your environment

Ubuntu 22

OS: Ubuntu 22.04.2 LTS
CLI: zsh
pip freeze command:

accelerate==0.22.0
aiohttp==3.8.5
aiosignal==1.3.1
annotated-types==0.5.0
async-timeout==4.0.3
attrs==23.1.0
autokey==0.96.0
beautifulsoup4==4.12.2
build==1.0.0
cachetools==5.3.1
certifi==2023.7.22
charset-normalizer==3.2.0
click==8.1.7
cmake==3.27.2
dataclasses-json==0.5.14
datasets==2.14.4
dill==0.3.7
evaluate==0.4.0
filelock==3.12.3
frozenlist==1.4.0
fsspec==2023.9.0
google==3.0.0
google-api-core==2.11.1
google-auth==2.22.0
googleapis-common-protos==1.60.0
greenlet==2.0.2
huggingface-hub==0.16.4
idna==3.4
install==1.3.5
Jinja2==3.1.2
joblib==1.3.2
langchain==0.0.279
langsmith==0.0.33
libxml2-python==2.11.5
lit==16.0.6
MarkupSafe==2.1.3
marshmallow==3.20.1
mpmath==1.3.0
multidict==6.0.4
multiprocess==0.70.15
mypy-extensions==1.0.0
networkx==3.1
nltk==3.8.1
numexpr==2.8.5
numpy==1.25.2
nvidia-cublas-cu11==11.10.3.66
nvidia-cuda-cupti-cu11==11.7.101
nvidia-cuda-nvrtc-cu11==11.7.99
nvidia-cuda-runtime-cu11==11.7.99
nvidia-cudnn-cu11==8.5.0.96
nvidia-cufft-cu11==10.9.0.58
nvidia-curand-cu11==10.2.10.91
nvidia-cusolver-cu11==11.4.0.1
nvidia-cusparse-cu11==11.7.4.91
nvidia-nccl-cu11==2.14.3
nvidia-nvtx-cu11==11.7.91
packaging==23.1
pandas==2.1.0
protobuf==4.24.2
psutil==5.9.5
pyarrow==13.0.0
pyasn1==0.5.0
pyasn1-modules==0.3.0
pydantic==2.3.0
pydantic_core==2.6.3
Pygments @ file:///tmp/pygments-20231008-7034-7mgm75/Pygments-2.16.1
pyinotify==0.9.6
pyproject_hooks==1.0.0
PyQt5==5.15.9
PyQt5-Qt5==5.15.2
PyQt5-sip==12.12.0
python-dateutil==2.8.2
python-xlib==0.33
pytz==2023.3
PyYAML==6.0.1
regex==2023.8.8
requests==2.31.0
responses==0.18.0
rsa==4.9
safetensors==0.3.3
scikit-learn==1.3.0
scipy==1.11.2
seqeval==1.2.2
six==1.16.0
soupsieve==2.5
span-marker==1.3.0
SQLAlchemy==2.0.20
sympy==1.12
tabulate @ file:///tmp/python-tabulate-20230101-7916-1x927co/tabulate-0.9.0
tenacity==8.2.3
threadpoolctl==3.2.0
tokenizers==0.13.3
torch==2.0.1
tornado==6.3.3
tqdm==4.66.1
transformers==4.32.1
triton==2.0.0
typing-inspect==0.9.0
typing_extensions @ file:///tmp/python-typing-extensions-20231008-6782-q1yw07/typing_extensions-4.8.0
tzdata==2023.3
urllib3==1.26.16
xxhash==3.3.0
yarl==1.9.2

Activity

  1. changed the title [-]Named Queries more user firendly[/-] [+]Add a way to edit named queries from an external editor[/+] on May 31, 2026
  2. dbaty commented on May 31, 2026

    @dbaty
    Member

    I would like to skip the named query show at the top when I'm running it - I want only the results - I have big queries and I need to scroll them every time. It can be via config vile parameter.

    That part has been implemented (623633a) with a new hide_named_query_text option. It's yet to be released.

    The other requested feature (being able to edit named queries from an external editor) could be interesting. It's not been implemented yet. Contributions are welcome! :)

  3. j-bennet commented on Jun 3, 2026

    @j-bennet
    Contributor

    4.5.0 is released, with the first part in it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions