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 <[EMAIL PROTECTED]> writes:
> > On Wed, Oct 15, 2003 at 16:45:39 -0500,
> >   Ben Kim <[EMAIL PROTECTED]> 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
> 


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to