PostgreSQL - Import / export CSV

l-lin included in post

2020-04-15 23 words One minute

Export:

1
2


\copy (SELECT * FROM your_table)
TO '/tmp/your_table.csv' CSV HEADER FORCE QUOTE *;

Import:

1

\copy your_table FROM '/tmp/your_table.csv' CSV HEADER;