I think that PostgreSQL is great RDBMS, but one important (for me) feature that it missing is case-insensitive identifier quotes ([table].[column]) like in Microsoft SQL Server.
putting names in [ ] is not part of any SQL specification.
I know that there are double quotes, but they are case-sensitive.
Or maybe some option that will make double quotes case-insensitive.
the current behavior is compliant with the SQL specification. if you want case-insensitive, don't quote the identifiers. if you do quote them, they are implicitly case sensitive according to the specifications.
all identifier comparisons are case-sensitive - but unquoted identifiers are case-folded to lower-case (in contravention of the SQL IIRC) before the comparison is made.
