CascadiaPHP 2024


(PHP 5 >= 5.3.3, PHP 7, PHP 8)

PDO::pgsqlCopyToArrayCopy data from database table into PHP array


public PDO::pgsqlCopyToArray(
    string $table_name,
    string $delimiter = "\t",
    string $null_as = "\\\\N",
    string $fields = ?
): array|false

Copies data from table into array using delimiter as fields delimiter and fields list

Bağımsız Değişkenler


String containing table name


Delimiter used in rows


How to interpret null values


List of fields to export

Dönen Değerler

Returns an array of rows, başarısızlık durumunda false döner.

add a note

User Contributed Notes 1 note

Hayley Watson
5 years ago
The "rows" returned are strings, (hence the delimiter parameters for separating fields). They're not parsed into PHP arrays, so this isn't a substitute for $connection->query('SELECT * FROM table_name')->fetchAll().

Only the first character of $delimiter is used. Characters that may be used are those <32 except "\r", "\n" and NUL (chr(0)); anything from !"#$%&'()*+,-./:;<=>?@ABCDEFGHIJKMOPQRSTVWXYZ[]^_`{|}~, and DEL (chr(127)) (yes, upper-case letters are allowed, but lower-case ones are not).

Also, the $fields argument is a comma-separated list of the desired columns.
To Top