psql, tab completion additions

From: "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
To: pgsql-patches(at)postgresql(dot)org
Subject: psql, tab completion additions
Date: 2005-11-29 03:40:11
Message-ID: Pine.LNX.4.44.0511290353030.3502-200000@lnfm1.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hello All,

1) I'm proposing a patch to do the DROP FUNCTION argument tab completion.
Now, the arguments of the drop function can be tab completed. for example

drop function strpos (
<press tab>
drop FUNCTION strpos (text, text)

or:

wsdb=# drop FUNCTION length (
bit) bytea) character) lseg) path) text)
<press c>
wsdb# DROP FUNCTION length ( character)

I think that this patch should be rather useful. At it least I hate
always to type all the arguments of the dropped functions.

2) Also some fixes applied for the
CREATE INDEX syntax

now the parenthesises are inserted by tab pressing.
suppose I have the table q3c:
wsdb=# \d q3c
Table "public.q3c"
Column | Type | Modifiers
--------+------------------+-----------
ipix | bigint |
ra | double precision |
dec | double precision |

Now if I do
wsdb# create index xxx on q3c
<press tab>
wsdb# CREATE INDEX xxx on q3c (
<press tab>
wsdb=# CREATE INDEX xxx on q3c (
"dec" ipix ra
<press r>
wsdb=# CREATE INDEX xxx on q3c ( ra

Regards,
Sergey

*****************************************************
Sergey E. Koposov
Max-Planck Institut for Astronomy
Web: http://lnfm1.sai.msu.ru/~math
E-mail: math(at)sai(dot)msu(dot)ru

Attachment Content-Type Size
tab-complete.diff text/plain 2.6 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-11-29 06:16:53 Re: Reduce dependancies of postmaster (without --as-needed)
Previous Message Alvaro Herrera 2005-11-29 01:48:29 Re: Install pg_regress by default