On 6/25/2015 11:59 AM, Алексей Бережняк wrote:
> 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.
--
john r pierce, recycling bits in santa cruz