title: how to alter all view's owner in postgresql
body: <p>In <a href="/questions/tagged/postgresql-9.2" class="post-tag" title="show questions tagged &#39;postgresql-9.2&#39;" rel="tag">postgresql-9.2</a> <em>database</em> there are <code>125</code> <em>views</em> stored.Among them 75 <em>views</em> <em>owner</em> is <code>sa</code>.</p>
  
  <p>So,is there any method can I apply to <em>alter</em> the <em>view's</em> having <em>owner</em> <code>sa</code> to <code>postgres</code>.?</p>