Restore a table from a previous backup

The schema command file in this example extracts a table from the level-0 backup of dbspace1. The logical logs are used to bring the table to the time of "2003-01-01 01:01:01". The data is placed in the table test1:tlr.

database test1;
create table tlr (
   a_serial serial,
   b_integer integer,
   c_char char,
   d_decimal decimal
   ) in dbspace1;
insert into tlr select * from tlr;
restore to '2003-01-01 01:01:01';