Pdo\Pgsql::copyToFile

Copy data from table into file

Description

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

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