title: Drop table if exists in PostgreSQL database
body: <p>I am trying to drop table if it is exists in the present working database of PostgreSQL. For which I am trying the following query. </p>
  
  <p><strong>Example</strong>:</p>
  
  <pre><code>var1 := 'IF EXISTS (select * from INFORMATION_SCHEMA.TABLES WHERE name = ''Table_'|| Suffix ||''') then
        DROP TABLE Table_'||Suffix||'';
  
  execute var1;
  </code></pre>
  
  <p>But getting error near <code>IF</code>.</p>