Re: Uppercase to lowercase trigger?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Uppercase to lowercase trigger?
Date: 2012-05-03 07:56:05
Message-ID: 4FA23A15.6060105@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05/03/12 12:50 AM, Ken Tanzer wrote:
> What if you created separate tables with the fields in uppercase,
> either with different names or better yet the same names and a
> different schema? It seems you could put triggers on those tables,
> and have your trigger translate the field names and make the updates
> to the real tables instead.

if one of the applications is read only on this table, you could use a
view with the alternate version of the names.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2012-05-03 07:56:33 Re: Memory Management in pqlib, Garbage Collection support
Previous Message Ken Tanzer 2012-05-03 07:50:07 Re: Uppercase to lowercase trigger?