Re: case sensitivity on table & column names / workaround?

[postgresql(dot)org(at)tgice(dot)com]

Ludek Finstrle wrote:
> What about updateable views? It could be the way for replication and name
> changing. I'm not sure it's only an idea.

Yes, I'd loosely considered this but then figured it wouldn't work b/c I 
wouldn't be able to change the capitalization of the column identifiers 
as well, but I guess I can do that with 'AS's in my CREATE VIEW 
statement, eh?

Also, at the moment, the tables are readonly on the PG side so I don't 
even need them to be updateable, but it's good to know that that feature 
exists.

I suppose the is the best solution for now, though still not quite ideal 
of course.  Thanks for suggesting it, Luf; I'll give it a shot.

Any chance we might see some sort of feature in the ODBC driver (or the 
backend) in the future to e.g., check an option that says "Ignore double 
quotes on identifiers (and thus allow them to be folded to lower case)"?

Obviously, that'd probably be the most ideal situation for me here and 
perhaps anyone else who is doing something where they're tightly 
integrated with MSSQL or another backend that handles capitalization 
differently.

Thanks again,

jl