Pdo\Pgsql::copyFromFile
(PHP 8 >= 8.4.0)
Pdo\Pgsql::copyFromFile — Copy data from file into table
说明
string
$tableName,string
$filename,string
$separator = "\t",string
$nullAs = "\\\\N",?string
$fields = null): bool
Copies data from file specified by filename
into table tableName using
separator as fields delimiter and fields list
参数
tableName
String containing table name.
filename
Filename containing the data to import.
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 insert.
错误/异常
If filename cannot be opened for reading, 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::copyFromFile() example
The file holds one record per line, with fields joined by
separator (a tab by default).
<?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)');
file_put_contents('/tmp/fruits.tsv', "1\tapple\t10\n2\tbanana\t20\n");
$db->copyFromFile('fruits', '/tmp/fruits.tsv');
echo $db->query('SELECT count(*) FROM fruits')->fetchColumn(), "\n";
?>以上示例会输出:
2
参见
- Pdo\Pgsql::copyToFile() - Copy data from table into file
- 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。离线整理了版式、链接和媒体显示。
