question re double quotes

From: Ben Kim <bkim(at)edsun(dot)coe(dot)tamu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: question re double quotes
Date: 2003-10-15 21:45:39
Message-ID: Pine.GSO.4.10.10310151628330.13839-100000@edsun.coe.tamu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I wonder if it is possible to let psql recognize Mixed-case-named
("LikeThisName") table names without double quotes in sql statements.

Thanks to the readline, the table name seems to autoexpand to the full
name "LikeThisName", if I just type in "Like" and press the tab key. But
when I execute the sql statement, it gives me

ERROR: Relation "likethisname" does not exist.

Obviously psql uniquely recognizes the name without double quotes (being
able to autoexpand) but won't accept its own creation as valid...

The bash shell in cygwin recognizes both cases and presents choices, if I
put this line in .inputrc.
# Ignore case while completing
set completion-ignore-case on

Is there such a feature already? Or, could I submit it as a suggestion? We
have many table and field names with double quotes, so it will save us a
lot of keystrokes. (Also perhaps some errors related with using Access as
frontend...)

Even if we use mixed-case names, it's primarily for descriptive names, and
we don't use same-letters-different-case names.

Regards,
Ben

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ben Kim 2003-10-15 21:58:18 question re crosstab query
Previous Message Ryan Chambers 2003-10-15 21:34:39 understanding postgres stats