CREATE TABLE a ( id integer, message varchar ); CREATE VIEW b AS SELECT upper(message) AS msg FROM a; INSERT INTO a VALUES (1, "Hello,"); INSERT INTO a VALUES (2, "world!");