pgcli

Instead of psql, I really like https://github.com/dbcli/pgcli

In what way did it blow up? You must have hit a bug, using .pg_service should work. Would you care to open an issue on https://github.com/dbcli/pgcli/issues or just dump the error message here so we can investigate?

The latest version of pgcli is pypi was released on Dec 11 2020. There are only a few changes unreleased in the master branch. https://github.com/dbcli/pgcli/blob/master/changelog.rst What feature are you waiting for? I can talk to the project lead to see if we can push out a new release if needed.

https://github.com/dbcli/pgcli is my favorite terminal client for postgres. It has smart completion, syntax highlighting, and more.

A few of the ones I use almost daily - Pandoc a handy document format converter: https://pandoc.org/ - Ripgrep, a faster grep: https://github.com/BurntSushi/ripgrep - There are quite a few prompt-toolkit based CLI which have been really nice: * mycli (https://github.com/dbcli/mycli), pgcli (https://github.com/dbcli/pgcli) * ptpython/ptipython (https://github.com/prompt-toolkit/ptpython) - Youtube-dl: http://rg3.github.io/youtube-dl/ - fzf a fuzzy finder for the console: https://github.com/junegunn/fzf - jq for JSON manipulation: https://stedolan.github.io/jq/ - Miller for CSV/TSV: https://github.com/johnkerl/miller I would imagine you have already scoured the "awesome" lists: https://github.com/agarrharr/awesome-cli-apps#terminal-utili...

Formatting: Written in Rust - fd: A simple, fast and user-friendly alternative to 'find' https://github.com/sharkdp/fd - ripgrep: ripgrep recursively searches directories for a regex pattern https://github.com/BurntSushi/ripgrep - exa: Replacement for 'ls' written in Rust https://github.com/ogham/exa - bat: A 'cat' replacement. I recommend following the customizations. https://github.com/sharkdp/bat Written in Python - asciinema: Terminal session recorder https://github.com/asciinema/asciinema - httpie: Modern command line HTTP client https://github.com/jakubroztocil/httpie - visidata: A terminal spreadsheet multitool for discovering and arranging data https://github.com/saulpw/visidata - youtube-dl: Command-line program to download videos from YouTube.com and other video sites https://github.com/rg3/youtu

Written in Rust: - fd: A simple, fast and user-friendly alternative to 'find' https://github.com/sharkdp/fd - ripgrep: ripgrep recursively searches directories for a regex pattern https://github.com/BurntSushi/ripgrep - exa: Replacement for 'ls' written in Rust https://github.com/ogham/exa - bat: A 'cat' replacement. I recommend following the customizations. https://github.com/sharkdp/bat Written in Python: - asciinema: Terminal session recorder https://github.com/asciinema/asciinema - httpie: Modern command line HTTP client https://github.com/jakubroztocil/httpie - visidata: A terminal spreadsheet multitool for discovering and arranging data https://github.com/saulpw/visidata - youtube-dl: Command-line program to download videos from YouTube.com and other video sites

Not an UI but I love pgcli (https://github.com/dbcli/pgcli), it's like psql but 10 times better. It works pretty well

honest question, when would you query several tables without joining them somewhere? you can do that on postgres as well btw, my first idea would be to create a function [1] and just throw the rows together. still can't imagine a usecase for that though, i'd always want to get them separately if they're unrelated. you're correct on the GUI side however. Everything i've tried is a buggy mess. i've actually mostly given up on that front and just went with pgcli [2]. its pretty good for ad hoc queries. But it doesn't really help if you're trying to write a function. Its just nice for selects with lots of joins or nested selects. [1] https://www.postgresql.org/docs/9.1/static/sql-createfunctio... [2] https://github.com/dbcli/pgcli

This should be integrated into pgcli [0] [1]! [0]: http://pgcli.com [1]: https://github.com/dbcli/pgcli