title: Postgresql: Check if Schema Exists?
body: <p>I need to create, manage and drop schemas on the fly. If I go to create a schema that already exists, I want to (conditionally, via external means) drop and recreate it as specified. How can I check for the existence of said schema on my Postgres 9 server?</p>
  
  <p>Currently, I'm doing this:</p>
  
  <pre><code>select exists (select * from pg_catalog.pg_namespace where nspname = 'schemaname');
  </code></pre>
  
  <p>but I feel like there's probably another way... is this the "proper" way to query Postgres for the existence of a particular schema?</p>