psql duplicate a table with data code example Example: copy table postgres CREATE TABLE new_table AS TABLE existing_table;