pgcli Alternatives & Comparisons JavaScript is most known as the scripting language for Web pages, but used in many non-browser environments as well such…

What tools integrate with pgcli? What tools integrate with Redsmin? JavaScript is most known as the scripting language for Web pages, but used in many no…

Need advice about which tool to choose?Ask the StackShare community! Developers describe pgcli as "Postgres CLI with autocompletion and syntax highlighti…

Resource Consumption: OPM may require more resources to run efficiently due to its monitoring and data visualization features, while pgcli is lightweight…

Saved searches Use saved searches to filter your results more quickly You signed in with another tab or window. Reload to refresh your session.You signed…

Saved searches Use saved searches to filter your results more quickly You signed in with another tab or window. Reload to refresh your session.You signed…

Saved searches Use saved searches to filter your results more quickly You signed in with another tab or window. Reload to refresh your session.You signed…

This year (2018) we are qualified as an OpenSource sponsor for PyCon. We will have a booth and will be showing demos of pgcli, mycli and mssql-cli at the…

Django web framework has a rich set of management commands. One of them is python manage.py dbshell. This will launch the default database repl and conne…

Heroku is a popular PAAS provider that offers managed Postgres database. Heroku provides a convenience command to connect to the postgres database, which…

The trouble is ipython doesn't have the ability to do auto-completion for the sql statements. So it's a bit hard to iterate on the sql statement to get t…

Pgcli keeps track of the queries entered in the repl. Up/Down arrow can be used to navigate the history. Pressing <C-r> will enable incremental history s…

Pgcli outputs query results in a pager (e.g. less , more ). This allows you to easily view large result sets one page at a time. Configuring the Pager Whe…

Who? The main author of vcli is Chang-Hung Liang. He took the source code for pgcli and repurposed it to work with VerticaDB. The vcli project will be ho…

Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using: $pipinstal…

Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using: $pipinstal…

Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using: $pipinstal…

Why? pgcli is a community project now and having an organization helps solidify that. More peope will now have write access to the repo. Watch for the an…

FAQ These are some questions that the author wishes everyone would ask, since he knows the answers for them. Why does pgcli exist? I'm a huge fan of CLIs…

Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using: $pipinstal…

About 2 years ago I (Amjith) made a modest announcement about launching pgcli a CLI client for Postgres with auto-completion. Since then pgcli has grown …

Who? The main author of vcli is Chang-Hung Liang. He took the source code for pgcli and repurposed it to work with VerticaDB. The vcli project will be ho…

Prompt Pgcli provides a configurable prompt. When pgcli starts up, it will use the prompt configuration found in its config file. Once pgcli is running u…

Daniel made pgcli handle JSON, bytea, and large decimal values correctly. He improved the completion matching by adding sub-string matching. His creative…

Editor One of the most useful slash commands is \e. This will launch an editor to edit the current query (or previous query, if the current query is blan…

This is a major update with a ton of new features a lot of bug fixes. Some of the highlights include support for Redshift and Postgres 8.x versions. Adde…

Configuration Introduction Most of pgcli's user settings are configured via the file located at ~/.config/pgcli/config, which is a hidden file in your ho…

IPython integration Pgcli can be run from within IPython console. When working on a query, it may be useful to drop into a pgcli session without leaving …

This version adds support for \\h command and \x auto command. Two very important commands that bring us close to being a total replacement for psql. Thi…

This release comes with the latest version of prompt_tookit, improved auto-completion support, better matching algorithm in auto-completion, new special …

Install Compatibility: I have not personally tested this on Windows, but all the underlying libraries used by this project are cross-platform compatible …

Add support for PGPASSWORD environment variable to pass the password for the postgres database. (Thanks: Iryna Cherniavska) Add the ability to manually r…

This is a minor bug-fix release that fixes unicode issues with hstore. Bug Fixes: Fix unicode issues with hstore. Previously the unicode type caster for …

This release comes with metadata information in the completion menus. Now you can see whether a completion suggestion is a table or a schema or a view. N…

This version adds more color schemes to the syntax highlighting. An attempt to add support for PyPy by using psycopg2cffi failed. Python 3 support for ps…

Setup a remote called upstream that points to the original pgcli repo. This is to keep your fork in sync with the mainline. gitremoteaddupstreamgit@githu…

Docker Pgcli can be run from within Docker. This can be useful to try pgcli without installing it, or any dependencies, system-wide. To build the image: …

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of …

Docker Pgcli can be run from within Docker. This can be useful to try pgcli without installing it, or any dependencies, system-wide. To build the image: $…

Installers conda install To install this package run one of the following: conda install conda-forge::pgcliconda install conda-forge/label/cf201901::pgcli…

NAME pgcli - CLI for PostgreSQL with auto-completion and syntax highlighting SYNOPSIS pgcli [OPTIONS] [DATABASE] [USERNAME] DESCRIPTION pgcli is a command…

pgcli Alternatives & Comparisons JavaScript is most known as the scripting language for Web pages, but used in many non-browser environments as well such…

What tools integrate with pgcli? What tools integrate with Redsmin? JavaScript is most known as the scripting language for Web pages, but used in many no…

Need advice about which tool to choose?Ask the StackShare community! Developers describe pgcli as "Postgres CLI with autocompletion and syntax highlighti…

Resource Consumption: OPM may require more resources to run efficiently due to its monitoring and data visualization features, while pgcli is lightweight…

Saved searches Use saved searches to filter your results more quickly You signed in with another tab or window. Reload to refresh your session.You signed…

Saved searches Use saved searches to filter your results more quickly You signed in with another tab or window. Reload to refresh your session.You signed…

Saved searches Use saved searches to filter your results more quickly You signed in with another tab or window. Reload to refresh your session.You signed…

This year (2018) we are qualified as an OpenSource sponsor for PyCon. We will have a booth and will be showing demos of pgcli, mycli and mssql-cli at the…

Django web framework has a rich set of management commands. One of them is python manage.py dbshell. This will launch the default database repl and conne…

Heroku is a popular PAAS provider that offers managed Postgres database. Heroku provides a convenience command to connect to the postgres database, which…

The trouble is ipython doesn't have the ability to do auto-completion for the sql statements. So it's a bit hard to iterate on the sql statement to get t…

Pgcli keeps track of the queries entered in the repl. Up/Down arrow can be used to navigate the history. Pressing <C-r> will enable incremental history s…

Pgcli outputs query results in a pager (e.g. less , more ). This allows you to easily view large result sets one page at a time. Configuring the Pager Whe…

Who? The main author of vcli is Chang-Hung Liang. He took the source code for pgcli and repurposed it to work with VerticaDB. The vcli project will be ho…

Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using: $pipinstal…

Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using: $pipinstal…

Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using: $pipinstal…

Why? pgcli is a community project now and having an organization helps solidify that. More peope will now have write access to the repo. Watch for the an…

FAQ These are some questions that the author wishes everyone would ask, since he knows the answers for them. Why does pgcli exist? I'm a huge fan of CLIs…

Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using: $pipinstal…

About 2 years ago I (Amjith) made a modest announcement about launching pgcli a CLI client for Postgres with auto-completion. Since then pgcli has grown …

Who? The main author of vcli is Chang-Hung Liang. He took the source code for pgcli and repurposed it to work with VerticaDB. The vcli project will be ho…

Prompt Pgcli provides a configurable prompt. When pgcli starts up, it will use the prompt configuration found in its config file. Once pgcli is running u…

Daniel made pgcli handle JSON, bytea, and large decimal values correctly. He improved the completion matching by adding sub-string matching. His creative…

Editor One of the most useful slash commands is \e. This will launch an editor to edit the current query (or previous query, if the current query is blan…

This is a major update with a ton of new features a lot of bug fixes. Some of the highlights include support for Redshift and Postgres 8.x versions. Adde…

Configuration Introduction Most of pgcli's user settings are configured via the file located at ~/.config/pgcli/config, which is a hidden file in your ho…

IPython integration Pgcli can be run from within IPython console. When working on a query, it may be useful to drop into a pgcli session without leaving …

This version adds support for \\h command and \x auto command. Two very important commands that bring us close to being a total replacement for psql. Thi…

This release comes with the latest version of prompt_tookit, improved auto-completion support, better matching algorithm in auto-completion, new special …

Install Compatibility: I have not personally tested this on Windows, but all the underlying libraries used by this project are cross-platform compatible …

Add support for PGPASSWORD environment variable to pass the password for the postgres database. (Thanks: Iryna Cherniavska) Add the ability to manually r…

This is a minor bug-fix release that fixes unicode issues with hstore. Bug Fixes: Fix unicode issues with hstore. Previously the unicode type caster for …

This release comes with metadata information in the completion menus. Now you can see whether a completion suggestion is a table or a schema or a view. N…

This version adds more color schemes to the syntax highlighting. An attempt to add support for PyPy by using psycopg2cffi failed. Python 3 support for ps…

Setup a remote called upstream that points to the original pgcli repo. This is to keep your fork in sync with the mainline. gitremoteaddupstreamgit@githu…

Docker Pgcli can be run from within Docker. This can be useful to try pgcli without installing it, or any dependencies, system-wide. To build the image: …

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of …