# Databases : PostgreSQL : Advanced : Views TODO ``` You can create a view over the query, which gives a name to the query that you can refer to like an ordinary table: CREATE VIEW myview AS SELECT name, temp_lo, temp_hi, prcp, date, location FROM weather, cities WHERE city = name; SELECT * FROM myview; Making liberal use of views is a key aspect of good SQL database design. Views can be used in almost any place a real table can be used. Building views upon other views is not uncommon. ```