Dump postgresql database to csv

pgdb2csv.sh

#!/bin/bash

DB_SCHEMA="public"
DB_USER="postgres"
DB_HOST="localhost"
DB_PORT="db_port"
DB_NAME="db_name"
# DB_PASS="" to be passed from shell

psql "postgresql://$DB_USER:$DB_PASS@$DB_HOST:$DB_PORT/$DB_NAME" -Atc "select tablename from pg_tables where schemaname='$DB_SCHEMA'" $DB_NAME |\
  while read TBL; do
    psql "postgresql://$DB_USER:$DB_PASS@$DB_HOST:$DB_PORT/$DB_NAME" -c "\copy $DB_SCHEMA.$TBL to stdout with (format csv, header true, delimiter ',');" $DB_NAME > $TBL.csv
  done