Hello,
I ran into similiar problems when migrating tables from MSSQL to Postgres. Typically I create table names such as "TableName" and column names such as "TableID" in MSSQL. If there exists a table called "TableName" and a column called "TableID" why won't the following query work in postgres:
SELECT TableID FROM TableName
I guess that my question is: why does Postgres muck around with the case? Double quoting all tables and columns in a database that contains dozens of tables is far too much work, and I don't understand why I need to drop all my labels to lowercase in the DB. Is there no way to override this behavior?
PostgreSQL is doing this as per the SQL spec (don't ask me what part, I'm just quoting what others have told me). You would get more knowledgable answers on one of the PostgreSQL lists - all I can really offer is advice on how pgAdmin can help you (by dropping the case or quoting).
Regards, Dave.
