From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Greg Sabino Mullane <greg(at)turnstep(dot)com> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: psql tab-complete: schema support, quotes, etc. |
Date: | 2002-07-24 01:54:46 |
Message-ID: | 200207240154.g6O1skJ16719@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Greg Sabino Mullane wrote:
> -----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-----
>
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-07-24 03:23:11 | inet support for contrib/array |
Previous Message | Christopher Kings-Lynne | 2002-07-24 01:45:06 | Re: [PATCHES] Demo patch for DROP COLUMN |