psql tab completion

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: am(at)fx(dot)ro
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: psql tab completion
Date: 2002-11-12 04:40:12
Message-ID: 1037076013.66615.11.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Clean up psql:

Add simple ALTER DATABASE, ALTER TRIGGER, CHECK POINT, CREATE
CONVERSION, CREATE DOMAIN, CREATE LANGUAGE, DEALLOCATE, DROP CONVERSION,
DROP DOMAIN, DROP LANGUAGE, EXECUTE, PREPARE

Complete CAST in CREATE CAST and DROP CAST but doesn't suggest what
should follow.

Add many more SET / SHOW variables to the list. Taken from SHOW ALL
output.

Complete a case sensitive search to allow \dD, \dd, \dS, \ds, \h, \H to
complete properly. But there are no matches, then try a case
insensitive search to allow case conversion. Add all missing help
options.

\Q<tab> -> \q
\dD<tab> -> \dD
\dd<tab> -> \dd
\D<tab><tab><tab> -> \d (with listing of \d? commands)
sel<tab> -> SELECT

> On the other hand, in psql , tab-completion doesn't seem to
> work for certain commands :
>
> ALTER DATABASE ; ALTER TRIGGER ; CHECKPOINT ; CREATE CAST ;
> CREATE CONSTRAINT TRIGGER ; CREATE CONVERSION ; CREATE DOMAIN ;
> CREATE LANGUAGE ; DEALLOCATE ; DROP CAST ; DROP CONVERSION ;
> DROP DOMAIN ; DROP LANGUAGE ; EXECUTE ; PREPARE
>
> ( this could be considered a low priority todo item , though )

--
Rod Taylor

Attachment Content-Type Size
psql.patch text/plain 9.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-11-12 05:05:16 RC1?
Previous Message Tatsuo Ishii 2002-11-12 04:39:41 Re: the map file between gb18030 and utf8 is error

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2002-11-12 04:57:37 Re: ON COMMIT temp table handling
Previous Message Bruce Momjian 2002-11-12 04:22:40 Re: ON COMMIT temp table handling