Re: psql tab completion enhancements

I will adjust this patch based on later feedback emails.

Your patch has been added to the PostgreSQL unapplied patches list at:

	http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------


Joachim Wieland wrote:
> Hi,
> 
> psql's tab completion has the following problem:
> 
> If we have the following syntax for example:
> 
> SET SESSION AUTHORIZATION ;
> SET SESSION AUTHORIZATION DEFAULT;
> 
> After "SET SESSION AUTHORIZATION", the tab completion can offer a list of
> roles or the string constant "DEFAULT". However it can't offer both because
> it can't get a list of roles and add a string constant to this list.
> 
> The appended patch adds the functionality of lists that can be extended with
> constants.
> 
> Then you get:
> 
> template1=# SET session AUTHORIZATION 
> DEFAULT  fred     joe      john
> 
> I did proof-of-concept examples to add a constant to a
> 
>  - list from a query
>  - list from a schema query
>  - list of table attributes
> 
> 
> Joachim
> 

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073