1 CREATE TABLE a (

     2 	id integer,

     3 	message varchar

     4 );

     5 

     6 CREATE VIEW b AS SELECT upper(message) AS msg FROM a;

     7 

     8 INSERT INTO a VALUES (1, "Hello,");

     9 INSERT INTO a VALUES (2, "world!");