Export Queries Results Data From PostgreSQL To CSV Using pgAdmin, PSQL, and Python

preview_player
Показать описание
This tutorial explains how to #export queries results from a PostgreSQL database to a CSV file using 3 different method.
The first method is to use pgAdmin, the second method consists of using PSQL via the terminal/cmd, and the third method is using python code (Pandas + SQLAlchemy)

Both #postgresql and #csv files are very popular meaning that you may use them at some point when working on a data related field.

This tutorial provides 3 different methods on how to achieve CSV export from PostgreSQL, and each method has its own use cases.

Code here:

Share & Subscribe to the channel :)

Into: (00:00)
pgAdmin: (00:25)
Terminal - PSQL: (03:11)
Script - Python: (10:28)
Outro: (18:03)

#python #subscribe #pythonprogramming #learnpython #exporttocsv
#postgresqltocsv
Рекомендации по теме