Pdo\Pgsql::copyFromFile

Copy data from file into table

Description

public bool Pdo\Pgsql::copyFromFile(
    string $tableName,
    string $filename,
    string $separator = "\t",
    string $nullAs = "\\\\N",
    stringnull $fields = null
)

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
  • Pdo\Pgsql::copyFromArray
  • Pdo\Pgsql::copyToArray