On Thu, May 3, 2012 at 2:29 AM, Chris Angelico <ros...@gmail.com> wrote: > On Wed, May 2, 2012 at 10:33 PM, Chrishelring > <christianhelr...@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 -- http://mail.python.org/mailman/listinfo/python-list
