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