export.php

<?php

require_once(__DIR__ . '/dibi.min.php');

dibi::connect(array(
	'driver' => 'postgre',
	'host' => 'localhost',
	'dbname' => 'database',
	'user' => 'username',
	'password' => '***',
	'charset' => 'utf8',
));

$tables = array('table1', 'table2');

///////////////////////////////////////////////////////

header('Content-Type: text/html; charset=utf-8');

function implodeEscape($glue, array $array) {
	foreach($array as $key => $value) {
		if (!is_numeric($value)) {
			$array[$key] = dibi::getConnection()->getDriver()->escape($value, dibi::TEXT);
		}
	}
	return implode(', ', $array);
}

foreach($tables as $table) {
	$result = dibi::fetchAll('SELECT * FROM %n', $table);
	foreach($result as $row) {
		$row = $row->toArray();
		echo 'INSERT INTO ' . $table . ' (' . implode(', ', array_keys($row)) . ') VALUES (' . 
		implodeEscape(', ' , $row) . ');';
		echo "<br />\n";
	}
}