PHP: Pdo\Pgsql::copyToFile

Description

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.

Parameters

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.

Return Values

Returns true on success or false on failure.

Errors/Exceptions

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.

Examples

Example #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');
?>

The above example will output:

1	apple	10
2	banana	20

Pdo\Pgsql::copyToFile

Description

Parameters

Return Values

Errors/Exceptions

Examples

See Also

Found A Problem?

User Contributed Notes