All Versions
54
Latest Version
Avg Release Cycle
60 days
Latest Release
551 days ago
Changelog History
Page 1
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:
- Port to psycopg3 (https://github.com/psycopg/psycopg).
- 🛠 Fix typos
-
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
- Add
-
v3.2.0 Changes
🚀 Release date: 2021/08/23
🔋 Features:
- ⚡️ Consider
update
queries destructive and issue a warning. Changedestructive_warning
setting toall|moderate|off
, vstrue|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)
- ⚡️ Consider
-
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
topendulum
for displaying query durations (#1015) - More explicit error message when connecting using DSN alias and it is not found.
- 👉 Make the output more compact by removing the empty newline. (Thanks:
-
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
_)
- Add
-
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
_ andAmjith 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
_)
- Escape switches to VI navigation mode when not canceling completion popup. (Thanks: