PostgreSQL Export table into CSV file

To export a table into CSV file, run

\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!

Leave a Reply

Your email address will not be published. Required fields are marked *