[GENERAL] Uppercase to lowercase trigger?

[Chris Angelico]

On Thu, May 3, 2012 at 2:29 AM, Chris Angelico <rosuav at gmail.com> wrote:
> On Wed, May 2, 2012 at 10:33 PM, Chrishelring
> <christianhelring at gmail.com> wrote:
>> Hi,
>>
>> I´ve got some tables with column names in lowercase. Before updatering these
>> tables I want to add a trigger that can convert these lowercase to
>> uppercase, and when the tables are updates convert them back to lowercase..
>
> Not entirely sure what you're looking for here, but in Postgres, if
> you don't quote your column names, they are lowercased by default.
>
> UPDATE some_table SET ColumnName = 'foo', COLUMNNAME2 = 'bar';
>
> This will work if the table has "columnname" and "columnname2".
>
> ChrisA

Take no notice of me... 'py'thon and 'pg'-sql are apparently too close
on my keyboard and brain...

ChrisA