I have a question regarding views on postgresql.
We have two views on two different schemas. One called "first" and the other one is called "second". We need the view "first" to be created and always have the same content as the view "second". When i say content i mean the query that constructed the view and not the result of the view.
In summary: query of view first changes->query of view second changes
Is something like this possible?
If you need more details you can ask me. Thanks in advance!