psql tab-complete: schema support, quotes, etc.

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

Added support for schemas and quotes in tab-complete.c, as well as
a few other things:

* Made all references to the pg_* tables absolute, by specifying
the pg_catalog schema.

* Added SCHEMA as a create/delete completion option.

* Added SCHEMA completion as: SELECT nspname FROM pg_catalog.pg_namespace
WHERE substr(nspname,1,%d)='%s'

* Added completion of "INSERT INTO <table> (" with attribute names.

* Added completion of "INSERT INTO <table> (attribs)" with
VALUES or SELECT

* Added limited locking completion: only for one table:
"LOCK" and "LOCK TABLE" now both get a completion list of tables
Complete with "IN" for LOCK [TABLE] <table>
Complete LOCK [TABLE] <table> IN with a lock mode

* Added a very simple WHERE finisher that uses the previous word
as a table lookup for attributes.

* Added quote support when parsing "previous words". In other words,
hitting tab after INSERT INTO "foo bar baby"
now does the right thing and recognizes "foo bar baby" as one word.

Letting tab-complete quote things that should be quoted seems to be
temporarily ifdef'ed out due to readline compatibility problems.
Can anyone elaborate on this?

Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200207222050

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE9PKkWvJuQZxSWSsgRAiwZAJ9bNO0qCw1v7evsLmkV00zE4B2I/QCePYzk
6bUQZru8Gj+2S5wPbsPrQio=
=id1t
-----END PGP SIGNATURE-----