sql - Copy table structure into new table

Question

Is there a way to copy the structure of a table into a new table, without data, including all keys and constraints?

Answer 1

For a simple schema copy use the like clause.

CREATE TABLE new_table_name (LIKE old_table_name INCLUDING ALL);