Re: question re double quotes

Thanks for the reply. I haven't looked at the source code yet, but
assuming I understood it correctly, if we can simply add double quotes
around tab-completed names, it alone would be very convenient.

Regards,
Ben

On Thu, 16 Oct 2003, Tom Lane wrote:

> Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> > On Wed, Oct 15, 2003 at 16:45:39 -0500,
> > Ben Kim <bkim(at)edsun(dot)coe(dot)tamu(dot)edu> wrote:
> >> I wonder if it is possible to let psql recognize Mixed-case-named
> >> ("LikeThisName") table names without double quotes in sql statements.
>
> > You probably don't want to create tables with mixed case names in the
> > first place.
>
> The real problem is that the tab-completion code doesn't work properly
> with quoted names. For example, if I do
>
> create table "MixedCase" (f1 int);
>
> then
>
> update M<tab>
>
> completes as
>
> update MixedCase
>
> which is wrong (no double quotes). Arguably it's my fault for not
> supplying the initial quote, but
>
> update "M<tab>
>
> fails to offer any completions at all. Somebody should work on this
> sometime.
>
> Actually, maybe all we need to do is apply quote_ident() in the
> tab-completion queries ... hmmm ...
>
> regards, tom lane
>