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