title: delete schemas with prefix
body: <p>I want to delete all the schema within a database that starts with <strong>'u_'</strong>, for some reason, I keep getting over 200 schema created whenever I try to create and modify tables in <strong>pgSQL</strong>.</p>
  
  <p>I tried using </p>
  
  <pre><code>drop schema u_* cascade;
  </code></pre>
  
  <p>but I don't think wildcards work like that (will get a syntax error code here). I know that I can get all the schema names through</p>
  
  <pre><code>select schema_name
  from information_schema.schemata;
  </code></pre>
  
  <p>but from there on I don't know what to do. I just want to delete all the schema that are either empty or start with "u_".</p>