postgresql copy 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;

Example 3: postgres copy command

COPY my_table FROM 'c:\downloads\file.csv' DELIMITERS ',' CSV QUOTE E'\'';

Example 4: postgres copy command

COPY my_table FROM 'c:\downloads\file.csv' DELIMITERS ',' CSV QUOTE '''';

Tags:

Sql Example

Related