Horton

Uppercase tab completion keywords in psql?

Bruce Momjian <bruce@momjian.us>

View thread
From: Bruce Momjian <bruce@momjian.us>
To: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Cc: Peter Eisentraut <peter_e@gmx.net>
Date: 2012-03-22T21:49:55Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. psql: Add variable to control keyword case in tab completion

  2. psql: Case preserving completion of SQL key words

Postgres 9.2 has been modified so psql no longer uppercases SQL keywords
when using tab completation, by this commit:

	commit 69f4f1c3576abc535871c6cfa95539e32a36120f
	Author: Peter Eisentraut <peter_e@gmx.net>
	Date:   Wed Feb 1 20:16:40 2012 +0200
	
	    psql: Case preserving completion of SQL key words
	
	    Instead of always completing SQL key words in upper case, look at 
	    the word being completed and match the case.
	
	    reviewed by Fujii Masao

For example, in 9.1:

	test=> sel<TAB>

becomes

	test=> SELECT

However, in 9.2, this will produce:

	test=> select

FYI, fortunately this will still complete as upper case:

	test=> Sel<TAB>

Robert Haas and I are disappointed by this change.  I liked the fact
that I could post nice-looking SQL queries without having to use my
capslock key (which I use as a second control key).  Any chance of
reverting this change?

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +