title: how to execute pgsql script in pgAdmin?
body: <p>I want to execute some <strong>pgScript</strong> directly from the <em>pgAdmin</em> editor UI.</p>
  
  <pre><code>FOR i IN 1..10 LOOP
     PRINT i; -- i will take on the values 1,2,3,4,5,6,7,8,9,10 within the loop
  END LOOP;
  </code></pre>
  
  <p>But I always got</p>
  
  <pre><code>[ERROR    ] 1.0: syntax error, unexpected character
  </code></pre>
  
  <p>I also tried to wrap the code with <strong>do$$...$$</strong>, but does not solve the problem.</p>