Join Discord
Powered by
when a table column data type changes does its vie...
# sql
j
jon.m
05/07/2022, 3:10 PM
when a table column data type changes does its view also update?
g
garyaustin
05/07/2022, 8:01 PM
As I understand it, no. You have to recreate the view.
j
jon.m
05/07/2022, 8:04 PM
Thanks Austin, I googled forever and couldn't find the answer. A test would suffice now. Thank you!
g
garyaustin
05/07/2022, 8:08 PM
Towards the bottom of this is one direct reference to it:
https://stackoverflow.com/questions/37129567/how-to-change-or-alter-column-type-in-views-using-postgresql
Previous
Next