All Versions
54
Latest Version
Avg Release Cycle
60 days
Latest Release
551 days ago

Changelog History
Page 1

  • v3.5.0 Changes

    September 15, 2022

    🔋 Features:

    • 🆕 New formatter is added to export query result to sql format (such as sql-insert, sql-update) like mycli.

    🐛 Bug fixes:

    • 🛠 Fix exception when retrieving password from keyring (issue 1338).
    • 🛠 Fix using comments with special commands (issue 1362).
    • 🏁 Small improvements to the Windows developer experience
    • 🛠 Fix submitting queries in safe multiline mode (1360).

    Internal:

  • v3.4.1 Changes

    March 19, 2022

    🐛 Bug fixes:

    • 🛠 Fix the bug with Redshift not displaying word count in status (related issue).
    • 👉 Show the error status for CSV output format.
  • v3.4.0 Changes

    February 21, 2022

    🔋 Features:

    • ➕ Add optional support for automatically creating an SSH tunnel to a machine with access to the remote database (related issue).
  • v3.3.1 Changes

    January 18, 2022

    🐛 Bug fixes:

    • 🛠 Prompt for password when -W is provided even if there is a password in keychain. Fixes #1307.
    • ⬆️ Upgrade cli_helpers to 2.2.1
  • v3.3.0 Changes

    January 11, 2022

    🔋 Features:

    • Add max_field_width setting to config, to enable more control over field truncation (related issue).
    • Re-run last query via bare \watch. (Thanks: Saif Hakim_)

    🐛 Bug fixes:

    • 📌 Pin the version of pygments to prevent breaking change
  • v3.2.0 Changes

    🚀 Release date: 2021/08/23

    🔋 Features:

    • ⚡️ Consider update queries destructive and issue a warning. Change destructive_warning setting to all|moderate|off, vs true|false. (#1239)
    • Skip initial comment in .pg_session even if it doesn't start with '#'
    • Include functions from schemas in search_path. (Amjith Ramanujam_)
    • Easy way to show explain output under F5

    🐛 Bug fixes:

    • 🛠 Fix issue where syntax_style config value would not have any effect. (#1212)
    • 🛠 Fix crash because of not found InputMode.REPLACE_SINGLE with prompt-toolkit < 3.0.6
    • 🛠 Fix comments being lost in config when saving a named query. (#1240)
    • 🛠 Fix IPython magic for ipython-sql >= 0.4.0
    • 🛠 Fix pager not being used when output format is set to csv. (#1238)
    • Add function literals random, generate_series, generate_subscripts
    • 🛠 Fix ANSI escape codes in first line make the cli choose expanded output incorrectly
    • 🛠 Fix pgcli crashing with virtual pgbouncer database. (#1093)
  • v3.1.0 Changes

    🔋 Features:

    • 👉 Make the output more compact by removing the empty newline. (Thanks: laixintao_)
    • ➕ Add support for using pspg as a pager (#1102)
    • ⚡️ Update python version in Dockerfile
    • 👌 Support setting color for null, string, number, keyword value
    • 👌 Support Prompt Toolkit 2
    • 👌 Support sqlparse 0.4.x
    • ⚡️ Update functions, datatypes literals for auto-suggestion field
    • ➕ Add suggestion for schema in function auto-complete

    🐛 Bug fixes:

    • 🛠 Minor typo fixes in pgclirc. (Thanks: anthonydb_)
    • 🛠 Fix for list index out of range when executing commands from a file (#1193). (Thanks: Irina Truong_)
    • 🚚 Move from humanize to pendulum for displaying query durations (#1015)
    • More explicit error message when connecting using DSN alias and it is not found.
  • v3.0.0 Changes

    April 10, 2020

    🔋 Features:

    • Add __main__.py file to execute pgcli as a package directly (#1123).
    • ➕ Add support for ANSI escape sequences for coloring the prompt (#1122).
    • ➕ Add support for partitioned tables (relkind "p").
    • ➕ Add support for pg_service.conf files
    • Add config option show_bottom_toolbar.

    🐛 Bug fixes:

    • 🛠 Fix warning raised for using is not to compare string literal
    • Close open connection in completion_refresher thread

    Internal:

    • ⬇️ Drop Python2.7, 3.4, 3.5 support. (Thanks: laixintao_)
    • 👌 Support Python3.8. (Thanks: laixintao_)
    • 🛠 Fix dead link in development guide. (Thanks: BrownShibaDog_)
    • ⬆️ Upgrade python-prompt-toolkit to v3.0. (Thanks: laixintao_)
  • v2.2.0 Changes

    December 04, 2019

    🔋 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
  • v2.1.1 Changes

    May 31, 2019

    🐛 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_)