« Changelog History


pgcli v1.2.0 Release Notes

  • 🔋 Features:

    • ➕ Add more specifiers to pgcli prompt. (Thanks: Julien Rouhaud_). \p for port info \# for super user and \i for pid.
    • ➕ Add \watch command to periodically execute a command. (Thanks: Stuart Quin_). > SELECT * FROM django_migrations; \watch 1 /* Runs the command every second */
    • ➕ Add command-line option --single-connection to prevent pgcli from using multiple connections. (Thanks: Joakim Koljonen_).
    • ➕ Add priority to the suggestions to sort based on relevance. (Thanks: Joakim Koljonen_).
    • 🔧 Configurable null format via the config file. (Thanks: Adrian Dries_).
    • ➕ Add support for CTE aware auto-completion. (Thanks: Darik Gamble_).
    • ➕ Add host and user information to default pgcli prompt. (Thanks: Lim H_).
    • 👍 Better scoping for tables in insert statements to improve suggestions. (Thanks: Joakim Koljonen_).

    🐛 Bug Fixes:

    • Do not install setproctitle on cygwin. (Thanks: Janus Troelsen_).
    • ↪ Work around sqlparse crashing after AS keyword. (Thanks: Joakim Koljonen_).
    • 🛠 Fix a crashing bug with named queries. (Thanks: Joakim Koljonen_).
    • 👍 Replace timestampz alias since AWS Redshift does not support it. (Thanks: Tahir Butt_).
    • Prevent pgcli from hanging indefinitely when Postgres instance is not running. (Thanks: Darik Gamble_)

    Internal Changes:

    • ⬆️ Upgrade to sqlparse-0.2.0. (Thanks: Tiziano Müller_).
    • ⬆️ Upgrade to pgspecial 1.6.0. (Thanks: Stuart Quin_).