Re: question re double quotes - Mailing list pgsql-admin

From Tom Lane
Subject Re: question re double quotes
Date
Msg-id 12138.1066326692@sss.pgh.pa.us
Whole thread Raw
In response to Re: question re double quotes  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: question re double quotes  (Ben Kim <bkim@edsun.coe.tamu.edu>)
List pgsql-admin
Bruno Wolff III <bruno@wolff.to> writes:
> On Wed, Oct 15, 2003 at 16:45:39 -0500,
>   Ben Kim <bkim@edsun.coe.tamu.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

pgsql-admin by date:

Previous
From: "lgama"
Date:
Subject: How do I unsuscribe?
Next
From: "Glenn Wiorek"
Date:
Subject: rebuild index question