title: postgres view update underlying table schema
body: <p>I have a postgresql database with a table <code>t</code> and a view <code>v</code> referencing <code>t</code>. Here <code>v</code> is selecting <code>t.*</code>.
  When I now add a field to <code>t</code>, <code>v</code> is not updated, the field does not appear in the view. I also realized that when I dump the schema, the view is not saved with <code>t.*</code>, but with <code>t.col1,t.col2...</code>.
  Is there a nice way to re the view else than just rerunning the definition?</p>
  <p>Also if I dropped a column in <code>t</code>, wouldn't this cause an error in <code>v</code>?</p>
  <p>By the way my postgres version is 11.14.0</p>