I don't believe there is any way to do this. If you search for "postgresql track ddl changes", you'll likely conclude that there is no simple way to do this in postgresql. There may be a way to do this but I think it will require some non trivial amount of hand coding. If others know otherwise, please let us know. MEP
On Tuesday, September 4, 2018 at 5:22:02 PM UTC-4, Daniel Barale wrote: > > Hello all, > > Type 2 slowly changing dimensions allow the creation of time consistent > data views. When used properly, you can view the data “as it was” at a > point in time. So if a query myself today, using a 3 years ago time > criteria, I’d be able to see my address then, not where I live now, in case > I moved during that period. > > My question is, can we do the same with DDL metadata? I mean, is there a > system that allows having a table structure at a point in time, and having > the same table with a different structure at another point in time? Like > for instance, a table T had 3 integer columns in 1/1/2013 and in 12/12/2015 > have the same 3 integer columns but also a date column added? > > Do u get my drift? Does Pivotal have a “tool” or feature to provide that? > > Ward regards > > Daniel Barale, > > Social Security Administration (USA) > > daniel.e.bar...@ssa.gov >
