« Changelog History


pgcli v0.20.0 Release Notes

  • 🔋 Features:

    • Perform auto-completion refresh in background. (Thanks: Amjith, Darik Gamble, Irina Truong). When the auto-completion entries are refreshed, the update now happens in a background thread. This means large databases with thousands of tables are handled without blocking.
    • ➕ Add CONCURRENTLY to keyword completion. (Thanks: Johannes Hoff_).
    • ➕ Add support for \h command. (Thanks: Stuart Quin_). This is a huge deal. Users can now get help on an SQL command by typing: \h COMMAND_NAME in the pgcli prompt.
    • ➕ Add support for \x auto. (Thanks: Stuart Quin_). \\x auto will automatically switch to expanded mode if the output is wider than the display window.
    • Don't hide functions from pg_catalog. (Thanks: Darik Gamble_).
    • Suggest set-returning functions as tables. (Thanks: Darik Gamble_). Functions that return table like results will now be suggested in places of tables.
    • Suggest fields from functions used as tables. (Thanks: Darik Gamble_).
    • Using pgspecial as a separate module. (Thanks: Irina Truong_).
    • 👉 Make "enter" key behave as "tab" key when the completion menu is displayed. (Thanks: Matheus Rosa_).
    • 👌 Support different error-handling options when running multiple queries. (Thanks: Darik Gamble_). When on_error = STOP in the config file, pgcli will abort execution if one of the queries results in an error.
    • Hide the password displayed in the process name in ps. (Thanks: Stuart Quin_)

    🐛 Bug Fixes:

    • 🛠 Fix the ordering bug in \\d+ display, this bug was displaying the wrong table name in the reference. (Thanks: Tamas Boros_).
    • Only show expanded layout if valid list of headers provided. (Thanks: Stuart Quin_).
    • 🛠 Fix suggestions in compound join clauses. (Thanks: Darik Gamble_).
    • 🛠 Fix completion refresh in multiple query scenario. (Thanks: Darik Gamble_).
    • 🛠 Fix the broken timing information.
    • 🛠 Fix the removal of whitespaces in the output. (Thanks: Jacek Wielemborek_)
    • 🛠 Fix PyPI badge. (Thanks: Artur Dryomov_).

    👌 Improvements:

    • 🚚 Move config file to ~/.config/pgcli/config instead of ~/.pgclirc (Thanks: inkn_).
    • 🚚 Move literal definitions to standalone JSON files. (Thanks: Darik Gamble_).

    Internal Changes:

    • 👌 Improvements to integration tests to make it more robust. (Thanks: Irina Truong_).