W3cubDocs

/PHP

Pdo\Pgsql::copyFromFile

(PHP 8 >= 8.4.0)

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

Description

public Pdo\Pgsql::copyFromFile(
 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

Parameters

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.

Return Values

Returns true on success or false on failure.

See Also

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

© 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.copyfromfile.php