W3cubDocs

/PHP

Pdo\Pgsql::copyToFile

(PHP 8 >= 8.4.0)

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

Description

public 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 insert.

Return Values

Returns true on success or false on failure.

See Also

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

© 1997–2025 The PHP Documentation Group
Licensed under the Creative Commons Attribution License v3.0 or later.
https://www.php.net/manual/en/pdo-pgsql.copytofile.php