postgresql how to copy a table 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;
CREATE TABLE new_table AS
TABLE existing_table;
CREATE TABLE new_table AS
SELECT
*
FROM
existing_table
WHERE
condition;