title: How to set autocommit in a Redshift SQL Session?
body: <p>I am connecting to AWS Redshift with a browser-based client JackDB.</p>
  
  <p>and try to run vacuum</p>
  
  <pre><code>VACUUM table_name;
  </code></pre>
  
  <p>of course get the following error</p>
  
  <pre><code>ERROR: VACUUM cannot run inside a transaction block
  </code></pre>
  
  <p>how can I set autocommit in SQL session, is there something in Redshift like</p>
  
  <pre><code>set autocommit=on;
  VACUUM table_name;
  set autocommit=off;
  </code></pre>
  
  <p>P.S.</p>
  
  <p>the official client recommended in Redshift documentation is SQL Workbench/J. It has the functionality "autocommit" to ensure the successful running of VACUUM command.</p>
  
  <p>but JackDB is more convinient and portable</p>