title: How to ALTER a view in PostgreSQL
body: <p>PostgreSQL does not allow altering a view (i.e. adding column, changing column orders, adding criterie etc.) if it has dependent objects. This is really getting annoying since you have to write a script to:</p>
  
  <ol>
  <li>Drop all the dependent objects,</li>
  <li>Alter the view,</li>
  <li>Recreate all the dependent objects back again.</li>
  </ol>
  
  <p>I understand that postgreSQL developers have very reasonable concerns to prevent altering views. But do you guys have any scripts/shot-cuts to do all those manual stuff in a single run?</p>