Answers for "postgres copy table structure from another database"

copy table postgres

CREATE TABLE new_table AS 
TABLE existing_table;

Posted by: Guest on April-08-2020

copy table postgres

CREATE TABLE new_table AS 
SELECT
*
FROM
    existing_table
WHERE
    condition;

Posted by: Guest on November-23-2020

Code answers related to "postgres copy table structure from another database"