On Wed, Jul 3, 2013 at 9:05 PM, Bruce Momjian <bruce@momjian.us> wrote:
Yes, both the identifier names and alias names are folded to lower case. I never thought of them as different, but you are right, they are, and we are non-standard in both areas. Sorry.
Any plans to fix this in next release or having a patch to fix this? The default PostgreSQL behavior is folding column names to lower case but when an alias is used it should fold as per alias name.
Note that adding quotes for aliases will be blessed by PostgreSQL and then those will be folded to upper case BUT this adds up to lot of changes in the SQL layer.