title: ERROR: type "public.geometry" does not exist
body: <p>I'm supposed to create a spatial database and have installed Postgres and added the PostGIS extension. </p>
  
  <p>When I try to add a column of type <code>public.geometry</code> it always gives an error message that </p>
  
  <blockquote>
    <p>geometry type doesn't exist</p>
  </blockquote>
  
  <p>I'm not familiar with Postgres, and I don't know what the solution can possibly be. I tried to Google it but found nothing.</p>