Ekre Ceannmor

Ekre is a computer science and statistics student at the Polish-Japanese Academy in Warsaw. They have experience as a private tutor and are branching into creating e-learning materials. In their free time, Ekre enjoys diving and writing challenging puzzles.

Back

29 Aug 2024

Ekre Ceannmor

How to Export Data from PostgreSQL into a CSV File

Do you need to quickly send data to a client or share a report for further analysis? A CSV file is a great sharing option! Let’s take a look at how you can use this format to export data from a PostgreSQL database. In this article, we will first review what the CSV file format is and why it’s handy when exporting your PostgreSQL database. Then we will export some example data from a real database using psql on the command line and pgAdmin, a free and open-source interface for PostgreSQL databases.