On Tue, Dec 11, 2007 at 11:05:25AM -0600, Ertel, Steve wrote: > is wrapped in quotes. Is there a setting to allow upper case and mixed > case names for database tables, fields, etc, without having to wrap each > in quotes?
No, sorry. The always-one-case rule for unquoted identifiers is ANSI conformant. As it happens, the ANSI rule also makes everything ALLCAPS, but PostgreSQL doesn't go that way (for historical reasons). A ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match