Β« Changelog History


pgcli v1.0.0 Release Notes

  • πŸ”‹ Features:

    • ⬆️ Upgrade to prompt-toolkit 1.0.0. (Thanks: Jonathan Slenders_).
    • βž• Add support for \o command to redirect query output to a file. (Thanks: Tim Sanders_).
    • βž• Add \i path completion. (Thanks: Anthony Lai_).
    • Connect to a dsn saved in config file. (Thanks: Rodrigo RamΓ­rez Norambuena_).
    • ⬆️ Upgrade sqlparse requirement to version 0.1.19. (Thanks: Fernando L. Canizo_).
    • βž• Add timestamptz to DATE custom extension. (Thanks: Fernando Mora_).
    • Ensure target dir exists when copying config. (Thanks: David Szotten_).
    • πŸ– Handle dates that fall in the B.C. range. (Thanks: Stuart Quin_).
    • Pager is selected from config file or else from environment variable. (Thanks: Fernando Mora_).
    • βž• Add support for Amazon Redshift. (Thanks: Timothy Cleaver_).
    • Add support for Postgres 8.x. (Thanks: Timothy Cleaver_ and Darik Gamble_)
    • Don't error when completing parameter-less functions. (Thanks: David Szotten_).
    • Concat and return all available notices. (Thanks: Stuart Quin_).
    • πŸ– Handle unicode in record type. (Thanks: Amjith Ramanujam_).
    • βž• Added humanized time display. Connect #396. (Thanks: Irina Truong_).
    • βž• Add EXPLAIN keyword to the completion list. (Thanks: Amjith Ramanujam_).
    • βž• Added sdist upload to release script. (Thanks: Irina Truong_).
    • Sort completions based on most recently used. (Thanks: Darik Gamble)
    • Expand '' into column list during completion. This can be triggered by hitting <tab> after the '' character in the sql while typing. (Thanks: Joakim Koljonen_)
    • βž• Add a limit to the warning about too many rows. This is controlled by a new config value in ~/.config/pgcli/config. (Thanks: AnΕΎe Pečar_)
    • πŸ‘Œ Improved argument list in function parameter completions. (Thanks: Joakim Koljonen_)
    • Column suggestions after the COLUMN keyword. (Thanks: Darik Gamble_)
    • Filter out trigger implemented functions from the suggestion list. (Thanks: Daniel Rocco_)
    • State of the art JOIN clause completions that suggest entire conditions. (Thanks: Joakim Koljonen_)
    • Suggest fully formed JOIN clauses based on Foreign Key relations. (Thanks: Joakim Koljonen_)
    • βž• Add support for \dx meta command to list the installed extensions. (Thanks: Darik Gamble_)
    • βž• Add support for \copy command. (Thanks: Catherine Devlin_)

    πŸ› Bugs:

    • πŸ›  Fix bug where config writing would leave a '~' dir. (Thanks: James Munson_).
    • πŸ›  Fix auto-completion breaking for table names with caps. (Thanks: Anthony Lai_).
    • πŸ›  Fix lexical ordering bug. (Thanks: Anthony Lai_).
    • πŸ‘‰ Use lexical order to break ties when fuzzy matching. (Thanks: Daniel Rocco_).
    • πŸ›  Fix the bug in auto-expand mode when there are no rows to display. (Thanks: Amjith Ramanujam_).
    • πŸ›  Fix broken \i after #395. (Thanks: David Szotten_).
    • πŸ›  Fix multi-way joins in auto-completion. (Thanks: Darik Gamble_)
    • Display null values as in expanded output. (Thanks: Amjith Ramanujam_).
    • πŸ‘ Robust support for Postgres version less than 9.x. (Thanks: Darik Gamble_)

    Internal Changes:

    • ⚑️ Update config file location in README. (Thanks: Ari Summer_).
    • Explicitly add wcwidth as a dependency. (Thanks: Amjith Ramanujam_).
    • Add tests for the format_output. (Thanks: Amjith Ramanujam_).
    • βœ… Lots of tests for pgcompleter. (Thanks: Darik Gamble_).
    • ⚑️ Update pgspecial dependency to 1.4.0.