Export to csv from psql (postgres)

daniel —Thu, 06/25/2015 - 4:57pm

You can use:
COPY TABLE_NAME TO STDOUT WITH CSV HEADER
to push the output to a csv file.

Navigation

daniel —Fri, 07/01/2011 - 12:51pm

It's not at all important to get it right the first time. It's vitally important to get it right the last time.

—

Andrew Hunt and David Thomas