SQLzoo.net

CREATE a VIEW.

Postgres

A view is a named SELECT statement.

In this example we show only European countries, we also show the population in millions.

Note how the columns of the table may be named.

Run the tidy code silently
Run set up code


Specific to Postgres
none

Related links:

  • CREATE, DROP and ALTER