title: PostgreSQL query to rename and change column type with single query
body: <p>In PostgreSQL if I need to rename and change a column data type, I run two separate queries to do so.</p>
  <p>To rename:</p>
  <pre class="lang-sql prettyprint-override"><code>ALTER TABLE tblName RENAME &lt;oldColumn&gt; TO &lt;newColumn&gt; 
  </code></pre>
  <p>and to change column type:</p>
  <pre><code>ALTER TABLE tblName ALTER COLUMN &lt;newColumn&gt; &lt;columnType&gt;.
  </code></pre>
  <p>But is there any way to do both of these works with a single query like the following MySQL query:</p>
  <pre><code>ALTER TABLE tblName CHANGE COLUMN &lt;oldColumn&gt; &lt;newColumn&gt; &lt;columnType&gt;
  </code></pre>