On Mon, Jun 23, 2014 at 6:25 PM, Jeff Janes <jeff.ja...@gmail.com> wrote:
> On Mon, Jun 23, 2014 at 3:53 PM, Andres Freund <and...@2ndquadrant.com>
> wrote:
>> On 2014-06-23 13:10:34 -0400, Robert Haas wrote:
>>> On Mon, Jun 23, 2014 at 9:10 AM, Kevin Grittner <kgri...@ymail.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.
>
> Cheers and Thanks,
GAAH. I specifically verified before hitting send that the attachment
was listed. Nevertheless, it isn't there.
Note to self: stop using gmail offline to compose mail with
attachments to send later, it prevaricates. Attempted again with
regular gmail this time.
Cheers,
Jeff
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c
new file mode 100644
index be5c3c5..dcd1b7d
*** a/src/bin/psql/tab-complete.c
--- b/src/bin/psql/tab-complete.c
*************** psql_completion(const char *text, int st
*** 3342,3347 ****
--- 3342,3354 ----
COMPLETE_WITH_LIST(my_list);
}
+ else if (pg_strcasecmp(prev2_wd, "search_path") == 0)
+ {
+ COMPLETE_WITH_QUERY(Query_for_list_of_schemas
+ " AND nspname not like 'pg\\_toast%%' "
+ " AND nspname not like 'pg\\_temp%%' "
+ " UNION SELECT 'DEFAULT' ");
+ }
else
{
static const char *const my_list[] =
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
