create duplicate table in postgresql code example

Example: copy table postgres

CREATE TABLE new_table AS 
TABLE existing_table;