Pdo\Pgsql::copyToFile
(PHP 8 >= 8.4.0)
Pdo\Pgsql::copyToFile — Copy data from table into file
说明
string
$tableName,string
$filename,string
$separator = "\t",string
$nullAs = "\\\\N",?string
$fields = null): bool
Copies data from table into file specified by filename
using separator as fields delimiter and
fields list.
参数
tableName
String containing table name.
filename
Filename to export data.
separator
Delimiter used to separate fields in an entry of the
rows array.
nullAs
How to interpret SQL NULL values.
fields
List of fields to export.
错误/异常
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
参见
- Pdo\Pgsql::copyFromFile() - Copy data from file into table
- Pdo\Pgsql::copyFromArray() - Copy data from a PHP array into a table
- Pdo\Pgsql::copyToArray() - Copy data from database table into PHP array
来源:PHP Documentation Group · 作者与贡献记录 · CC BY 3.0。离线整理了版式、链接和媒体显示。
