title: How To change or alter column type in Views using PostgreSQL?
body: <p>I have a view, one of he column is timetaken type integer i want to change it as numeric.For this I used below syntax</p>
  
  <pre><code>ALTER VIEW view_timesheets  ALTER COLUMN timetaken type numeric;
  </code></pre>
  
  <p>When I run this I got the exception as </p>
  
  <blockquote>
    <p>"view_timesheets" is not a table, composite type, or foreign table</p>
  </blockquote>
  
  <p>Please explain how to alter column type.Thank You</p>