(PHP 8 >= 8.4.0)
Pdo\Pgsql::copyToFile — Copy data from table into file
$tableName,$filename,$separator = "\t",$nullAs = "\\\\N",$fields = null
Copies data from table into file specified by filename
using separator as fields delimiter and
fields list.
tableNamefilenameseparatorrows array.
nullAsNULL values.
fields
If filename cannot be opened for writing, or cannot be
written to, the failure is reported through the connection's error handling
(see PDO::ATTR_ERRMODE); with
PDO::ERRMODE_EXCEPTION a
PDOException is thrown.
Приклад #1 Pdo\Pgsql::copyToFile() example
The table is written to filename, one record per
line, with fields joined by separator.
<?php
$db = new Pdo\Pgsql('pgsql:dbname=test host=localhost', $user, $pass);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->exec('CREATE TABLE fruits (id int, name text, qty int)');
$db->exec("INSERT INTO fruits VALUES (1, 'apple', 10), (2, 'banana', 20)");
$db->copyToFile('fruits', '/tmp/fruits.tsv');
echo file_get_contents('/tmp/fruits.tsv');
?>Поданий вище приклад виведе:
1 apple 10 2 banana 20