If I enclose the lowercase table name in quotes then this works.select * from "abc" However, I don't want to enclose the tablename in quotes.
Table and column names which are enclosed in double quotes are case sensitive. Table and column names which are not enclosed in double quotes are case insensitive. This is standard behavior, not a bug. thanks, bryan
