title: How to enable quiet mode for Postgres commands on Heroku
body: <p>When using the <code>psql</code> command line utility on my local machine, I have the option to use the <code>-q</code> or <code>--quiet</code> switch to tell Postgres to do it's work quietly - i.e. it won't print every single <code>INSERT</code> statement to the console if you're doing a large import.</p>
  
  <p>Here's an example of how I'm using it:</p>
  
  <pre><code>psql -q -d &lt;SOME_DATABASE&gt; -f &lt;SOME_SQL_FILE&gt;
  </code></pre>
  
  <p>However, when using the <code>pg:psql</code> command line utility in Heroku, that option doesn't seem to be available. So I'm currently having to use it like so:</p>
  
  <pre><code>heroku pg:psql DATABASE -a &lt;SOME_HEROKU_APP&gt; &lt; &lt;SOME_SQL_FILE&gt;
  </code></pre>
  
  <p>which produces <em>a lot</em> of output to my console (hundreds of thousands of lines), because of the large size of the SQL file I'm importing. Whenever I try to use the <code>-q</code> or <code>--quiet</code> option, something like this:</p>
  
  <pre><code>heroku pg:psql DATABASE -q -a &lt;SOME_HEROKU_APP&gt; &lt; &lt;SOME_SQL_FILE&gt;
  </code></pre>
  
  <p>it'll throw an error saying that <code>-q</code> is not a valid option.</p>
  
  <p>Is there some way to enable quiet mode when running Postgres commands in Heroku?</p>