TIL - exporting-sql-query-to-csv

function _psql() {
    PGPASSWORD="${PGPASSWORD}" psql \
        -U "${PGUSER}" \
        -h "${PGHOST}" \
        -d "${DB}" \
        -v ON_ERROR_STOP=1 \
        -c "${1}"
}

_psql "
    COPY (
        SELECT
            id,
            created_at,
            conversation,
            session_key,
            user_id,
            archived
        FROM app_storedconversations
        WHERE created_at >= '${START_DATE}'
          AND created_at <  '${END_DATE}'
        ORDER BY created_at
    ) TO STDOUT WITH (FORMAT csv, HEADER true)
" > conversations.csv