="command">SELECT</code> command.
   The table columns have the
   names and data types associated with the output columns of the
   <code class="command">SELECT</code> (except that you can override the column
   names by giving an explicit list of new column names).
  </p><p>
   <code class="command">CREATE TABLE AS</code> bears some resemblance to
   creating a view, but it is really quite different: it creates a new
   table and evaluates the query just once to fill the new table
   initially.  The new t