Pgcli

==================

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

==================

Features:
---------

* Add `max_field_width` setting to config, to enable more control over field truncation ([related issue](https://github.com/dbcli/pgcli/issues/1250)).
* Re-run last query via bare `\watch`. (Thanks: `Saif Hakim`_)

Bug fixes:
----------

* Pin the version of pygments to prevent breaking change

=====

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)

=====

Features:
---------

* Make the output more compact by removing the empty newline. (Thanks: `laixintao`_)
* Add support for using [pspg](https://github.com/okbob/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.

=====

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

======

Features:
---------

* 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