copy in postgreaa code example
Example 1: copy table postgres
CREATE TABLE new_table AS
TABLE existing_table;
Example 2: postgres copy command
COPY my_table FROM 'c:\downloads\file.csv' DELIMITERS ',' CSV QUOTE '''';
CREATE TABLE new_table AS
TABLE existing_table;
COPY my_table FROM 'c:\downloads\file.csv' DELIMITERS ',' CSV QUOTE '''';