Re: Better psql tab-completion support for schemas and tables

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Better psql tab-completion support for schemas and tables
Дата
Msg-id
19784.1206818594@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Better psql tab-completion support for schemas and tables Greg Sabino Mullane <greg@turnstep.com>
Re: Better psql tab-completion support for schemas and tables Tom Lane <tgl@sss.pgh.pa.us>
Re: Better psql tab-completion support for schemas and tables Bruce Momjian <bruce@momjian.us>
Greg Sabino Mullane  writes:
> Full support for all schema and table name combinations when 
> getting a list of attributes. All of the following will now work:

> select * from information_schema.columns where 
> select * from foo where 
> select * from "user" where 
> select * from "foo" where 
> select * from "Uppercase".lower where 
> select * from "gtsm.com"."foo.Bar" where 
> select * from "GTSM.com".foo where 

Applied with minor revisions.  I noticed while testing this that
although you fixed it for the case of the user having unnecessarily
quoted the preceding name, for example given a table foo,

	update "foo" set 

it's still not bright about letting you complete such an entry in the
first place -- try

	update "f

That doesn't invalidate this patch, but there's still more work to do
on the completion queries.

			regards, tom lane
В списке pgsql-patches по дате отправления
От: Heikki Linnakangas
Дата:
От: Magnus Hagander
Дата:
FAQ