It seems there is no support for creating a table as duplicate of
another by doing "create table foo as select * from bar".

The only way seems to be do a create table foo followed by
insert into bar select * from foo;

But this requires I specify all the table columns during the create table.

Is there a workaround for duplicating a table without specifying all
the columns of the original table explicitly ?

Thanks.