iteral">joe</code> owns the pre-existing schema.)
</p><pre class="programlisting">
CREATE SCHEMA IF NOT EXISTS test AUTHORIZATION joe;
</pre><p>
  </p><p>
   Create a schema and create a table and view within it:
</p><pre class="programlisting">
CREATE SCHEMA hollywood
    CREATE TABLE films (title text, release date, awards text[])
    CREATE VIEW winners AS
        SELECT title, release FROM films WHERE awards IS NOT NULL;
</pre><p>
   Notice that the individual subcommands do not end with semicolons.
  <