Use `psql` to download data as CSV file

Although SQL WorkBench is a handy tool for querying AWS Redshift, we still need to CLI tool for automation.
To install psql on MacOS, we need to

Then we could download data without using \copy but only –csv

One thought on “Use `psql` to download data as CSV file

  1. Qi Yin

    Hi Mr.Dong,I learned about your blog from one of your articles “poll&epoll in the kernel”. Thank you for you selfless sharing! It helped me a lot.I am a student at school and I will follow you to server in AILBABA

    Reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.