Timestamping an existing table

To prepare an existing table for browsing, use alter table to add a column named timestamp. For example:

alter table oldtable add timestamp

A timestamp column with a null value is added to each existing row. To generate a timestamp, update each row without specifying new column values.

For example:

update oldtable
set col1 = col1