Restore to an external table

The schema command file in this example extracts a table called test1:tlr from the most recent backup of dbspace1 and places the data in a file called /tmp/tlr.unl.

database test1;
create table tlr
(a_serial serial,
  b_integer integer
) in dbspace1;
create external table tlr_dest
  (a_serial serial,
   b_integer integer
  ) using ("/tmp/tlr.unl", delimited );
insert into tlr_dest select * from tlr;
restore to current with no log;