Data manipulationPostgreSQL
COPY
Bulk import or export table data using CSV or text formats.
Command
\copy FROM '.csv' CSV HEADER;
Example usage
Load CSV data or export filtered subsets efficiently.
\copy <table> FROM '<path>.csv' CSV HEADER;\copy (SELECT * FROM <table> WHERE created_at >= NOW() - INTERVAL '7 days') TO STDOUT WITH CSVRelated tags
Data manipulationdatabasesqlpsql