<p>
  </p><p>
   To copy a table completely, the short form using
   the <code class="literal">TABLE</code> command can also be used:

</p><pre class="programlisting">
CREATE TABLE films2 AS
  TABLE films;
</pre><p>
  </p><p>
   Create a new temporary table <code class="literal">films_recent</code>, consisting of
   only recent entries from the table <code class="literal">films</code>, using a
   prepared statement.  The new table will be dropped at commit:

</p><pre class="programlisting">
PREPARE recentfi