title: Cannot create a new table after "DROP SCHEMA public"
body: <p>Since I wanted to drop some tables and somebody suggested the below and I did it:</p>
  
  <pre><code>postgres=# drop schema public cascade;
  DROP SCHEMA
  postgres=# create schema public;
  CREATE SCHEMA
  </code></pre>
  
  <p>Then I got problem when creating a new database, such as:</p>
  
  <pre><code>postgres=# create database test;
  CREATE DATABASE
  postgres=# \c test
  You are now connected to database "test" as user "postgres".
  test=# create table hi(id int primary key);
  *ERROR:  no schema has been selected to create in*
  </code></pre>
  
  <p>You can see I got error  </p>
  
  <blockquote>
    <p>ERROR:  no schema has been selected to create in*</p>
  </blockquote>
  
  <p>How can I restore the public schema?<br>
  I suggest people never do "drop schema public cascade;" if we don't know how to restore. Can somebody help me out?</p>