how to copy full table to new table in postgresql code example
Example 1: copy table postgres
CREATE TABLE new_table AS
TABLE existing_table;
Example 2: copy table postgres
CREATE TABLE new_table AS
SELECT
*
FROM
existing_table
WHERE
condition;