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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
