Release v0.14.0

A huge release that adds completion support for schemas.

Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can upgrade using:

$ pip install -U pgcli

Check detailed instructions if you're having difficulty.


  • Add alias completion support to ON keyword. (Thanks: Iryna Cherniavska)
  • Add LIMIT keyword to completion.
  • Auto-completion for Postgres schemas. (Thanks: darikg)
  • Better unicode handling for datatypes, dbname and roles.
  • Add timing command to time the sql commands. This can be set via config file (~/.pgclirc) using timing = True.
  • Add different table styles for displaying output. This can be changed via config file (~/.pgclirc) using table_format = fancy_grid.
  • Add confirmation before printing results that have more than 1000 rows.

Bug Fixes:

  • Performance improvements to expanded view display (x).
  • Cast bytea files to text while displaying. (Thanks: Daniel Rocco)
  • Added a list of reserved words that should be auto-escaped.
  • Auto-completion is now case-insensitive.
  • Fix the broken completion for multiple sql statements. (Thanks: darikg)