Sometimes you don't have the access to do a nice COPY

psql-to-csv.php

<?php

$psqlDelimiter = '|';
$outputDelimiter = ';';

$file = new SplFileObject(__DIR__ . '/psql.csv');
$output = new SplFileObject(__DIR__ . '/output.csv', 'w');

$i = 0;
while (!$file->eof()) {
    if ($i === 1) {
        $file->fgetcsv($psqlDelimiter);
        $i++;
        continue;
    }

    $row = array_map('trim', $file->fgetcsv($psqlDelimiter));
    $output->fputcsv($row, $outputDelimiter);

    $i++;
}