psql, tab completion additions - Mailing list pgsql-patches

From Sergey E. Koposov
Subject psql, tab completion additions
Date
Msg-id Pine.LNX.4.44.0511290353030.3502-200000@lnfm1.sai.msu.ru
Whole thread Raw
Responses Re: psql, tab completion additions  ("Sergey E. Koposov" <math@sai.msu.ru>)
List 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@sai.msu.ru


Attachment

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Install pg_regress by default
Next
From: Tom Lane
Date:
Subject: Re: Reduce dependancies of postmaster (without --as-needed)