Creating a View

* A view is a stored query that acts as a virtual table.

* Construct a view with the "CREATE VIEW" SQL command:

test=> CREATE VIEW emp_F AS SELECT employee_id AS id, first_name AS private_name, last_name AS family_name FROM employees WHERE last_name LIKE 'F%' \g
CREATE
test=>
test=> SELECT * FROM emp_F \g
id|private_name|family_name
--+------------+-----------
 1|Shlomi      |Fish       
23|Sarah       |Ferguson   
26|Falk        |Fish       
24|Michael     |Faraday    
71|Tamar       |Fish       
(5 rows)

* Note: At the moment, PostgreSQL views are read-only.