View definition with projection

To create a view with all the rows of the titles table, but with only a subset of its columns, enter:

create view titles_view 
as select title, type, price, pubdate 
from titles

No column names are included in the create view clause. The view titles_view inherits the column names given in the select list.