We can use different editors for writing SQL queries. You can toggle the autocompletion with the F2 key, it is officially called as Smart-Completion as you would see in the bottom left corner of the shell. PGCLI shell has an auto-completion feature that will provide some suggestions based on the recent queries or commands executed or the default options. We can even execute shell commands by using the ! in normal mode where we will be prompted for the command executed in the same window. We can use i or a for entering into insert mode, dd to delete the entire line, cc or S to delete the current line and enter into insert mode, yy to yank line, and p to paste, u for undo, etc. We can use hjkl keybinding for movement and other normal mode keymaps like w for moving a word, or b for moving a word in the backward direction, e to the end of the word, etc. Though it's nice that PGCLI offers a VI-mode, it is great for people using Vim, when using the Shell for editing a Query, this mode can be utilized. The Emacs-mode is just a normal typing experience without any modes or shortcut macros and other stuff. We can switch between these modes with F4 key. We can use two modes in PGCLI prompt, one is the Emacs mode which is the default one and the other is Vi-mode for Vim fanboys. We can even use j and k for moving vertically in an output table. We get an excellent table display of output which we can view by scroll or arrow keys.
Pgcli windows install#
There are a lot of ways pgcli can be installed, my preferred way is with pipx, it just works well and you don't have to install it every time or mess up your global python packages environment.Įnter fullscreen mode Exit fullscreen mode The package acts as a CLI for accessing and executing any SQL queries, so we can simply provide the options/parameters to plug the database in and access the schema and its related data. PGCLI allows us to interact with any Postgres database via the command line, it can be a remote database or a local database, you can access it right away from your terminal. PGCLi is a python package that acts as a CLI for executing SQL queries in a Postgres database. This article will cover the basics of using the PGCLI tool to perform simply as well as advanced options in interacting with your Postgres database. If you are like CLIs and love to play with backend systems like Postgres(database) then chances are you will love this article. We can simply execute SQL queries in a PSQL-like shell with additional features like autocompletion, text-editing modes, file input/output options, etc. It's PGCLI, that can act as an editor window for writing SQL queries for Postgres Databases. Have you ever used the Postgres database and did you know you don't have to launch PGAdmin every time you want to write SQL queries, you can write down those queries even inside a terminal with a python package.
0 kommentar(er)
