SQL

copy table postgres

CREATE TABLE new_table AS 
SELECT
*
FROM
    existing_table
WHERE
    condition;

postgres copy table

Syntax:
CREATE TABLE new_table AS 
TABLE existing_table;