Re: [GENERAL] How to drop column from interrelated views

I've got some functions on my own :) If you prefer to do it from SQL level I've got two functions prepared which first secure then restore all missing views definitions. -- secure all views DO $$ BEGIN --drop schema migration cascade CREATE SCHEMA migration; CREATE TABLE migration.views AS

Re: [GENERAL] How to drop column from interrelated views

On Sun, Jul 9, 2017 at 9:56 AM, Berend Tober wrote: > Guyren Howe wrote: > >> On Jul 8, 2017, at 16:11 , Berend Tober bto...@computer.org>> >> wrote: >> >>> >>> Guyren Howe wrote: >>> I’ve a set of interrelated views. I want to drop a column from

Re: [GENERAL] How to drop column from interrelated views

Guyren Howe wrote: On Jul 8, 2017, at 16:11 , Berend Tober > wrote: Guyren Howe wrote: I’ve a set of interrelated views. I want to drop a column from a table and from all the views that cascade from it. I’ve gone to the leaf dependencies and