pgcli v2.2.0 Release Notes

Release Date: 2019-12-04 // 4 months ago
  • 🔋 Features:

    • ➕ Add support for ANSI escape sequences for coloring the prompt (#1123).
    • ➕ Add \\G as a terminator to sql statements that will show the results in expanded mode. This feature is copied from mycli. (Thanks: Amjith Ramanujam_)
    • ✂ Removed limit prompt and added automatic row limit on queries with no LIMIT clause (#1079) (Thanks: Sebastian Janko_)
    • Function argument completions now take account of table aliases (#1048). (Thanks: Owen Stephens_)

    🐛 Bug fixes:

    • Error connecting to PostgreSQL 12beta1 (#1058). (Thanks: Irina Truong_ and Amjith Ramanujam_)
    • Empty query caused error message (#1019) (Thanks: Sebastian Janko_)
    • History navigation bindings in multiline queries (#1004) (Thanks: Pedro Ferrari_)
    • Can't connect to pgbouncer database (#1093). (Thanks: Irina Truong_)
    • 🛠 Fix broken multi-line history search (#1031). (Thanks: Owen Stephens_)
    • 🛠 Fix slow typing/movement when multi-line query ends in a semicolon (#994). (Thanks: Owen Stephens_)
    • 🛠 Fix for PQconninfo not available in libpq < 9.3 (#1110). (Thanks: Irina Truong_)

    Internal:

    • Add optional but default squash merge request to PULL_REQUEST_TEMPLATE

Previous changes from v2.1.1

  • 🐛 Bug fixes:

    • Escape switches to VI navigation mode when not canceling completion popup. (Thanks: Nathan Verzemnieks_)
    • Allow application_name to be overridden. (Thanks: raylu_)
    • 🛠 Fix for "no attribute KeyringLocked" (#1040). (Thanks: Irina Truong_)
    • Pgcli no longer works with password containing spaces (#1043). (Thanks: Irina Truong_)
    • Load keyring only when keyring is enabled in the config file (#1041). (Thanks: Zhaolong Zhu_)
    • 🚀 No longer depend on sqlparse as being less than 0.3.0 with the release of sqlparse 0.3.0. (Thanks: VVelox_)
    • 🛠 Fix the broken support for pgservice . (Thanks: Xavier Francisco_)
    • Connecting using socket is broken in current master. (#1053). (Thanks: Irina Truong_)
    • 👍 Allow usage of newer versions of psycopg2 (Thanks: Telmo "Trooper"_)
    • ⚡️ Update README in alignment with the usage of newer versions of psycopg2 (Thanks: Alexander Zawadzki_)

    Internal:

    • ➕ Add python 3.7 to travis build matrix. (Thanks: Irina Truong_)
    • Apply black to code. (Thanks: Irina Truong_)