On 6/28/17 23:52, Thomas Munro wrote: > 2. SQL:2011 temporal tables track system time and/or valid time with > columns that users create and then declare to be temporal control > columns. I don't think they show up unless you name them directly (I > didn't check the standard but I noticed that it's that way in another > product), so I guess that's basically the same as (1).
In my reading of the standard, those start/end time columns would show up normally in SELECT *. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers