copy from|to csv in postgresql

copy from|to csv.sql

-- Save without header
copy ((select "name", "email from "user") to '/absolute-path-to-directory/filename.csv' delimiter ',' csv; 

-- Save with header
copy ((select "name", "email from "user") to '/absolute-path-to-directory/filename.csv' delimiter ',' csv header; 


-- When having issue `must be superuser or a member of pg_write_server_files role COPY to a file`, add a `\` in front of `copy`
\copy ((select "name", "email from "user") to '/absolute-path-to-directory/filename.csv' delimiter ',' csv; 


-- copy csv to table
\copy "user" ("organizationId") from '<enter path>' delimiter ',' csv;