Bunch of tab-completion enhancements for psql - Mailing list pgsql-patches

From Greg Sabino Mullane
Subject Bunch of tab-completion enhancements for psql
Date
Msg-id 1116283685.17911.5.camel@localhost.localdomain
Whole thread Raw
Responses Re: Bunch of tab-completion enhancements for psql
Re: Bunch of tab-completion enhancements for psql
List 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@turnstep.com
PGP Key: 0x14964AC8 200505161845
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

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


Attachment

pgsql-patches by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Quick little \h enhancement for psql
Next
From: Neil Conway
Date:
Subject: Re: Bunch of tab-completion enhancements for psql