What is “psql2csv” Package?

Run a query in psql and output the result as CSV
For more details: https://github.com/fphilipe/psql2csv

Installation

  • Open Terminal by pressing command+space then type terminal and hit Enter key.
  • Install homebrew first.
    ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" < /dev/null 2> /dev/null
  • Install psql2csv.
    brew install psql2csv

Now, use psql2csv!