Maybe I should clarify what I mean. I have a db (postgresql 8.4.1 with a postGIS spatial extension) with about 200+ tables in it. Some of them is supposed to be updated using an application what requres that some of the columns are in uppercase (a leftover from Oracle I suppose) but the main application that uses these tables requres that the columns are in lowercase. I had an idea that using a trigger I could chance the columns from lowercase to uppercase before updating /changing the tables and after the update chance them back to lowercase. Is that possible and how do I do that?
Christian -- View this message in context: http://postgresql.1045698.n5.nabble.com/Uppercase-to-lowercase-trigger-tp5680384p5682473.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
