Question: how to create table like another table in postgresql?
Answer: Name. CREATE TABLE AS -- define a new table from the results of a query.
Synopsis. CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE table_name [ (column_name [, ...] ) ] [ ... 
Description. CREATE TABLE AS creates a table and fills it with data computed by a SELECT command.