Re: tab completion for setting search_path

On Mon, Jul 7, 2014 at 8:51 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> On Tue, Jun 24, 2014 at 11:57 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>> On Mon, Jun 23, 2014 at 6:25 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>>> On Mon, Jun 23, 2014 at 3:53 PM, Andres Freund <andres(at)2ndquadrant(dot)com>
>>> wrote:
>>>> On 2014-06-23 13:10:34 -0400, Robert Haas wrote:
>>>>> On Mon, Jun 23, 2014 at 9:10 AM, Kevin Grittner <kgrittn(at)ymail(dot)com>
>>>>> wrote:
>>>>> > I would be for excluding the pg_toast, pg_toast_temp_n, and
>>>>> > pg_temp_n schemas, and including public and pg_catalog.
>>>>>
>>>>> +1.
>>>>
>>>> Jeff, are you willing to update the patch that way? Seems we have
>>>> something several people can live with ;)
>>>
>>> I was hoping not to add a third set of filters (separate from the ones
>>> already implicit in either \dn or \dnS), but that's OK; as long as I get a
>>> doghouse I won't worry much about the color.
>>>
>>> I've included information_schema as well, in analogy to the inclusion of
>>> pg_catalog.
>
> Is there any blocker on this patch? The patch looks good to me.

The patch makes the tab-completion on search_path display the existing
schemas, additionally what about displaying "$user", too? I think that
some users would want to include "$user" variable in search_path.

Regards,

--
Fujii Masao