All Versions
54
Latest Version
Avg Release Cycle
60 days
Latest Release
189 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: