title: How to cascade the data type of a column of a table in postgres
body: <p>I have a PostgreSQL database and I need to change the data type of a column. There is a view that uses that table. Is there any way to change the data type of the column without deleting the view using <code>ALTER TABLE table_name ALTER COLUMN column_name TYPE new_type</code>.</p>