Re: psql, tab completion additions - Mailing list pgsql-patches

From Sergey E. Koposov
Subject Re: psql, tab completion additions
Date
Msg-id Pine.LNX.4.44.0512050715430.22088-200000@lnfm1.sai.msu.ru
Whole thread Raw
In response to psql, tab completion additions  ("Sergey E. Koposov" <math@sai.msu.ru>)
Responses Re: psql, tab completion additions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: psql, tab completion additions  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Now the patch have been made using "cvs diff -c"

Sergey

On Tue, 29 Nov 2005, Sergey E. Koposov wrote:

> 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
>
>

*****************************************************
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: Tom Lane
Date:
Subject: Re: port/snprintf.c (was Re: Numeric 508 datatype)
Next
From: Bruce Momjian
Date:
Subject: Re: psql, tab completion additions