group several columns together in materialized view
There are two ways to specify the name of a view column:


Do it with a column list:

CREATE VIEW myview (colname1, colname2) AS
SELECT appa.appa_id,
       font.font_id
FROM appa JOIN font ON ...;

Do it with aliases in the defining query:

CREATE VIEW myview AS
SELECT appa.appa_id AS colname1,
       font.font_id AS colname2
FROM appa JOIN font ON ...;