title: Postgres 9.4 Create Table if not exists like
body: <p>This statement is throwing syntax errors:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS "weChat_data_abc" LIKE "weChat_data_sample"
  </code></pre>
  
  <p>The table weChat_data_sample exists and is empty.</p>
  
  <p>I get the error: </p>
  
  <pre><code>Error : ERROR:  syntax error at or near "LIKE"
  </code></pre>
  
  <p>Output of SELECT VERSION():</p>
  
  <p>PostgreSQL 9.4.4 on x86_64-apple-darwin14.4.0, compiled by Apple LLVM version 6.1.0 (clang-602.0.53) (based on LLVM 3.6.0svn), 64-bit</p>