Handling CSV Imports and Exports in PostgreSQL

As a memo, I will write how to import csv and export csv in PostgreSQL.

First , login PostgreSQL Database and execute command below.

Export to CSV

\copy TABLE_NAME to path_to_filename.csv delimiter ',' csv header;

Import from CSV

\copy TABLE_NAME from path_to_filename.csv delimiter ',' csv header;