title: Syntax error on Truncate SELECT table_name
body: <p>I'm using PostgreSQL and I try to truncate all tables starting with <code>'beach'</code>.<br>
  In other words I would like to do something like:</p>
  
  <pre><code>Truncate (SELECT table_name
            FROM information_schema.tables
            WHERE table_schema = 'public' AND table_name LIKE 'beach_%')
  </code></pre>
  
  <p>Any ideas?</p>