PostgreSQL Export table into CSV file

To export a table into CSV file, run

\copy TABLE_NAME to 'FILE_NAME.csv' csv header;

1	\copy TABLE_NAME to 'FILE_NAME.csv' csv header;

This will save the CSV file in current directory.

Need help with Linux Server or WordPress? We can help!