PostgreSQL view modification?

Question

PostgreSQL

Good afternoon!

How can I modify the sql code-content of a view that already exists? Deleting, making changes affect the base tables of the view?

Answer 1

Drop view + create view new. Without cascade, deletion only affects the view itself. So it may be necessary to similarly delete and re-create other functions/views/etc that refer to the mutable view