[PostgreSQL] Import CSV File & export CSV File

 

IMPORT 

CREATE TABLE persons (
  id SERIAL,
  first_name VARCHAR(50),
  last_name VARCHAR(50),
  dob DATE,
  email VARCHAR(255),
  PRIMARY KEY (id)
)

persons.csv

0.00MB

COPY persons(first_name, last_name, dob, email)
FROM 'C:\sampledb\persons.csv'
DELIMITER ','
CSV HEADER;

---

 

EXPORT

\copy (SELECT * FROM persons) to '\tmp\persons_client.csv' with csv