Hello list,

May I know is there a way to "alter column type to varchar" (previous is varchar(***)) without view drop/re-creation?

Basically, looking for a way to change column without have to drop/re-create dependent views.

varchar(***) to varchar and no date/numeric changes.

Thanks a lot!
Emi
---
PostgreSQL 8.3.18 on x86_64