How To: Export Data From Postgres Database to CSV Format in Easy Steps

How To Export Data From Postgres Database to CSV Format in Easy Steps

Multi Language around, feel free to check all the available, and pick the one which is better for you!

*Commands used in this video*
---
psql -d dbname -t -A -F"," -c "select * from users"

echo "select id,name from hosts" | su - postgres -c "psql foreman"
echo "select id,name from hosts" | su - postgres -c "psql -A -F',' foreman"
echo "select id,name from hosts" | su - postgres -c "psql -t -A -F',' foreman"
echo "select id,name from hosts" | su - postgres -c "psql --csv foreman"
---

*Would you Like to Collab?*

*Contact*

*Editor*