Why not use COPY TO yournewtable STRU ?
>Has anyone written a 'Create Table command' generation program that will create that command by evaluating a real table?
>
>If so, do you mind sharing? We have several large tables (many fields) that we want to start creating programmatically, and I don't want to manually build the entire 'CREATE TABLE' command.
>
>Thanks, Michael