Skip to content

Instantly share code, notes, and snippets.

@rskuipers

rskuipers/psql-to-csv.php

Created April 29, 2016 09:46
Show Gist options
  • Save rskuipers/a24142c6265b306b2e591697d70c1abc to your computer and use it in GitHub Desktop.
Save rskuipers/a24142c6265b306b2e591697d70c1abc to your computer and use it in GitHub Desktop.
Download ZIP
Sometimes you don't have the access to do a nice COPY
Raw
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++;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment