Reddit
reddit.com › r/postgresql › anybody using pgcli instead of psql?
r/PostgreSQL on Reddit: Anybody using pgcli instead of psql?
December 26, 2017 -
If so, what are your main benefits from using pgcli? Anything you're missing in it that you had in psql?
Jannik Arndt
jannikarndt.de › blog › examining a postgresql with psql or pgcli
Examining a PostgreSQL with psql or pgcli | Jannik Arndt
August 16, 2018 - The PostgreSQL installation comes with a great tool, psql, to administer and inspect the database. pgcli extends this with syntax highlighting and autocompletion.
Psql command line tutorial and cheat sheet
Even as someone already comfortable with psql, pgcli is extremely handy · SELECT * FROM parent JOIN child USING (user_id) I personally think naming your primary keys with their full name instead of calling all of them `id` or `key` is better practice also More on news.ycombinator.com
44
328
November 17, 2020Can't connect to database by pgcli
docker run -it \ -e POSTGRES_USER="root" \ -e POSTGRES_PASSWORD="root" \ -e POSTGRES_DB="ny_taxi" \ -v $(pwd)/ny_taxi_postgres_data:/var/lib/postgresql/data \ -p 5432:5432 \ postgres:13 Here is the command that I use to create database. When container has been created, another folder with similar ... More on forums.docker.com
10
1
August 13, 2022postgresql - How to allow pgcli to show query result in prompt window, instead of editor? - Stack Overflow
pgcli is a command line tool, and I want it to show query result in prompt window. By default, it shows the result in an editor. How can I change the configuration? ... Save this answer. ... Show activity on this post. If you mean the pager that psql invokes by default to display long result ... More on stackoverflow.com
Ask HN: What PostgreSQL client do you use?
What client(s) do HN use day-to-day? Why have you chosen it · I'm looking for recommendations to use for light usage. Ideally, something that would help build the schema visually More on news.ycombinator.com
57
61
May 19, 2020Videos
GitHub
github.com › dbcli › pgcli › issues › 110
pgcli compare to psql? · Issue #110 · dbcli/pgcli
January 12, 2015 - i use pgcli and psql to access db. i found pgcli is slow when i post a query, psql is faster. "\timing off/on" is not support in pgcli, it works better on psql "\h create table" is not support in pgcli, it works better on psql "\h XXX XX...
Author dbcli
StackShare
stackshare.io › stackups › pgcli-vs-postgresql
PostgreSQL vs pgcli | What are the differences? | StackShare
PostgreSQL - PostgreSQL is an advanced ... triggers, user-defined types and functions. pgcli - This is a postgres client that does auto-completion and syntax highlighting....
Hacker News
news.ycombinator.com › item
Psql command line tutorial and cheat sheet | Hacker News
November 17, 2020 - Even as someone already comfortable with psql, pgcli is extremely handy · SELECT * FROM parent JOIN child USING (user_id) I personally think naming your primary keys with their full name instead of calling all of them `id` or `key` is better practice also
Nulogy
til-engineering.nulogy.com › pgcli-a-great-alternative-to-psql
pgcli — a great alternative to psql
Presenting, pgcli — a result of pouring creativity into features rather than the name of the tool. ... Smart autocompletion for almost anything. Even column names in the select query are properly autocompleted from the table you are selecting from; ... CLI parameters compatible with psql params.
DBI Services
dbi-services.com › accueil › simplifying postgresql management: a guide to install and use pgcli
Simplifying PostgreSQL Management: A Guide to Install and Use pgcli
August 18, 2023 - 1. Syntax Highlighting: SQL commands you enter are color-coded for easier readability. 2. Auto-Completion: pgcli provides suggestions for table and column names · 3. Multi-Line Editing: Unlike psql, you can write and edit multi-line queries with ease.
Terminal Trove
terminaltrove.com › home › macos › pgcli
pgcli - A postgres CLI with autocompletion and syntax highlighting. - Terminal Trove
May 26, 2025 - pgcli is a command-line PostgreSQL client with auto-completion and syntax colouring, built for quick interactive querying directly from the terminal.
Pgcli
pgcli.com
pgcli
pgcli also supports many of the same environment variables as psql for login options (e.g.
Neon
neon.com › docs › connect › connect-pgcli
Connect with pgcli - Neon Docs
February 3, 2025 - The pgcli client is an interactive command-line interface for Postgres that offers several advantages over the traditional psql client, including syntax highlighting, autocompletion, multi-line editing, and query history.
TigerData
tigerdata.com › blog › state-of-postgresql-2022-13-tools-that-arent-psql
State of PostgreSQL 2022—13 Tools That Aren't psql
November 28, 2024 - Although this is not a replacement for psql, it provides an interactive, auto-complete interface for writing SQL and getting results. Syntax highlighting and some basic support ...
StackShare
stackshare.io › stackups › pgcli-vs-postgresql-modeler
pgcli vs PostgreSQL Modeler | What are the differences? | StackShare
Developers describe pgcli as "Postgres CLI with autocompletion and syntax highlighting". This is a postgres client that does auto-completion and syntax highlighting. On the other hand, PostgreSQL Modeler is detailed as "PostgreSQL Database Modeler".
Pgcli
pgcli.com › tag › postgres
pgcli - postgres
Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using: ... This release adds new special commands \ev and \ef, more table formats, and a --user alias for --username option, to be compatible with psql.
Docker Community
forums.docker.com › docker hub
Can't connect to database by pgcli - Docker Hub - Docker Community Forums
August 13, 2022 - docker run -it \ -e POSTGRES_USER="root" \ -e POSTGRES_PASSWORD="root" \ -e POSTGRES_DB="ny_taxi" \ -v $(pwd)/ny_taxi_postgres_data:/var/lib/postgresql/data \ -p 5432:5432 \ postgres:13 Here is the command that I use to create database. When container has been created, another folder with similar name appears on my directory.
Hacker News
news.ycombinator.com › item
Ask HN: What PostgreSQL client do you use? | Hacker News
May 19, 2020 - What client(s) do HN use day-to-day? Why have you chosen it · I'm looking for recommendations to use for light usage. Ideally, something that would help build the schema visually
Top answer 1 of 2
1
The command line tool which comes bundled with Oracle is SQL*Plus. Find out more.
SQL*Plus is now a rather old tool so it doesn't necessarily do everything we'd want in a command line tool, or do things in the most intuitive fashion. Even its name looks old-fashioned. Oracle realise this and have a new product, sqlcl. It does lots of neat things (command history, autocompletion, scripting, oh my!) but it is a standalone download and install. Find out more.
2 of 2
0
If you want a general wrapper: GNU SQL http://www.gnu.org/s/parallel/sql.html
Top answer 1 of 2
16
I just found pgcli (https://github.com/dbcli/pgcli) — a postgres client that does auto-completion and syntax highlighting. It looks awesome!
Quick Start
If you already know how to install python packages, then you can simply do:
$ pip install pgcli
or
$ brew install pgcli # Only on OS X
If you don't know how to install python packages, please check the detailed instructions.
Usage
$ pgcli [database_name]
or
$ pgcli postgresql://[user[:password]@][netloc][:port][/dbname]
Examples:
$ pgcli local_database
$ pgcli postgres://amjith:[email protected]:5432/app_db
Source: https://github.com/dbcli/pgcli
2 of 2
0
I realize this is an old question and @honza-kasik 's a great reply. However, to further add to it, it should be pointed out that Debian-based Linux users should install via APT:
sudo apt install pgcli
Doing this saves a lot of headaches you'd have installing via pip
Pgcli
pgcli.com › faq
FAQ
When I started using psql for interacting with my Postgres database, I yearned for a BPython equivalent for psql. One fine day I got a twitter DM from Jonathan Slenders asking me if I'd be interested in trying a new Python library that he's working on called Python-Prompt-Toolkit. This library provided a way to write CLIs without having to deal with curses and had the requisite tools for doing auto-completion and syntax-highlighting. So I jumped at the opportunity to try it out. After I got myself familiarized, I started writing pgcli to scratch my own itch.
Hacker News
news.ycombinator.com › item
Show HN: Pgcli – A CLI for Postgres with auto-completion and syntax highlighting | Hacker News
January 8, 2015 - There is an FAQ page: http://pgcli.com/faq · I'll be happy to answer questions here as well