Re: [HACKERS] Case Preservation disregarding case

Ken Johanson skrev:

> Although, since I'm using pgAdmin (III) to design tables in this case,
> or creating the tables through JDBC (a convenient way to copy tables and
> data from another datasource) (using the copy-paste gesture), I believe
> those tools both *are* quoting identifiers that have camel case. And
> that their behavior can't be overridden.

I know nothing about JDBC but I've heard that pgAdmin always quote
identifiers. What you can do is to always create tables and columns
using lower case in pgadmin and then you can refer to them using any
case in your SQL (as long as you don't "Quote" the identifiers in your
SQL code).

> other users may not be. And having to recreate and issue the DDL to use
> un-quoted col names will be tedious in my case since I have ~20 tables
> to import.

Yes, it will be some work but it is at least possible to do a bunch of
renames.

> So my vote would remain for having a config-option to ignore case, even
> on quoted identifiers..

And my vote is to not have such an option. But I'm not the one who
decide so don't worry about what I think :-) I would like to have an
option to upper case the identifiers instead of lower casing them as pg
do. The sql standard say that they should be upper cased. But as far as
I know there are no plan at the moment to add such an option either.
Some time in the future I expect it to be implemented only because it's
the standard.

/Dennis