SW ENGINEERING/Postgres
[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) ) 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
2021. 9. 6. 11:19
최근댓글