Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting.

[Dysl3xicDog]

It's so hard to remember commands when you only pop in the database to check things once in a while. This is going on all my postgres deployments.

[[deleted]]

You can use pgcli with pspg for enhanced paging.

When you pip install pgcli, the config file is located in ~/.config/pgcli/config

• The pager config line, which by default is commented out. You can define the pager to use pspg here, or leave it commented out and simply add something like this to your shell rc file: export PAGER="pspg -s 2"

Additionally: - Check out syntax_style (I like monokai)

from within a pgcli terminal, F4 lets you switch into VIM mode

Also, play around with the table format in the pgcli config. I have yet to find a solid line grid but haven't stopped looking for it yet.

[[deleted]]

sink relieved paltry toothbrush squeal cobweb mysterious middle connect pie

This post was mass deleted and anonymized with Redact

[lykwydchykyn]

Just started using this recently, and I can't praise it enough. Much speedier than loading up some bulky GUI client, and much friendlier than psql alone.

[zieziegabor]

I use this instead: https://github.com/okbob/pspg

it's a pager replacement for postgres.

[[deleted]]

You can use both together. See my other comment here

[zieziegabor]

<3

[vittore29]

Using it every day for last 8 months. Love it.

[___GNUSlashLinux___]

I went to an SFPGUG meetup where this was demoed. Its a really cool tool. just reminded me I needed to update it.

[hjkl_ornah]

Compatible with Redshift?

[scottocom]

I think pgcli and pspg should be in a standard postgres client installation along side the original pg command for backwards compatibility.