Pdo\Pgsql::copyToFile

    (PHP 8 >= 8.4.0)

    Pdo\Pgsql::copyToFile — Copy data from table into file

    说明

    public function Pdo\Pgsql::copyToFile(
        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.

    返回值

    成功时返回 true， 或者在失败时返回 false。

    错误／异常

    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

    参见

    发现了问题？

    了解如何改进此页面 • 提交拉取请求 • 报告一个错误
    ＋添加备注

    用户贡献的备注

    此页面尚无用户贡献的备注。
    To Top