Richard_And_Trisha Back to postgreSQL, is there a way to use upper and lower case in sql statement ??
To use mixed case in column names you have to quote them, which is ugly, clumsy and error-prone enough that I resorted to underscores, e.g., presentation_name rather than "PresentationName". It's a fundamental design decision that I don't love about Postgres because it needlessly imposes a particular naming style.
As I understand it, the historical reason for this is the SQL language standard's rule is that unquoted identifiers must be normalized to one case. The standard actually specifies upper case, and I suppose we should count ourselves lucky that Postgres' early contributors chose to fold everything to lower case; otherwise, ALL_OUR_COLUMN_NAMES_WOULD_BE_SHOUTING_AT_US_ALL_DAY.
Still, I'm used to SQL parsing preserving casing while not being case-sensitive. That is how Sql Server works for example, and you only have to quote column names with spaces or that match TSQL keywords (and you quote them with square brackets rather than double quotes). I don't believe any other SQL DB works like PostgreSQL in this regard. It's a daily annoyance in an otherwise very nice DB.