Bunch of tab-completion enhancements for psql

From: Greg Sabino Mullane <greg(at)turnstep(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Bunch of tab-completion enhancements for psql
Date: 2005-05-16 22:48:06
Message-ID: 1116283685.17911.5.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Attached are some tab-completion enhancements for psql. In rough order,
they are:

* Made DELETE into "DELETE FROM"

* Moved ANALZYE to the end of the list to ease EXPLAIN / VACUUM
conflicts

* Removed the ANALYZE xx semicolon completion: we don't do that anywhere
else

* Add DECLARE support

* Add parens for DROP AGGREGATE

* Add "CASCADE | RESTRICT" for DROP xx

* Make EXPLAIN <tab> a lot smarter

* GROUP "BY" and ORDER "BY"

* "ISOLATION" becomes "ISOLATION LEVEL"

* Fix error in which REVOKE xx ON yy was receiving "TO", now gets "FROM"

* Add GRANT/REVOKE xx ON yy TO/FROM choices: usernames, GROUP, PUBLIC

* PREPARE xx <tab> AS "SELECT | INSERT | UPDATE | DELETE"

* Add = at end of UPDATE xx SET yy

* Beef up VACUUM stuff

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200505161845
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCiSKGvJuQZxSWSsgRAu72AKCpp9kOoXGt3+4Krew77ShzPhMaiQCdEU08
XYkiOCkrDdYILwEO3QQlLUk=
=NmML
-----END PGP SIGNATURE-----

Attachment Content-Type Size
tab-complete-plus.patch text/x-patch 12.2 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2005-05-17 01:12:32 Re: Bunch of tab-completion enhancements for psql
Previous Message Bruce Momjian 2005-05-16 22:42:39 Re: Exec statement logging