pg_copy_from
PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8
pg_copy_from - Insert records into a table from an array
Manual
pg_copy_from(
PgSql\Connection$connection,
string$table_name,
array$rows,
[string$separator = "\t"],
[string$null_as = "\\\\N"]
): bool
PgSql\Connection$connection,
string$table_name,
array$rows,
[string$separator = "\t"],
[string$null_as = "\\\\N"]
): bool
pg_copy_from inserts records into a table from rows. It issues a COPY FROM SQL command internally to insert records.
Parameters
- connection
-
An PgSql\Connection instance.
- table_name
-
Name of the table into which to copy the rows.
- rows
-
An array of data to be copied into table_name. Each value in rows becomes a row in table_name. Each value in rows should be a delimited string of the values to insert into each field. Values should be linefeed terminated.
- separator
-
The token that separates values for each field in each element of rows. Default is \t.
- null_as
-
How SQL NULL values are represented in the rows. Default is \\N ("\\\\N").
Return Values
Returns true on success or false on failure.
Changelog
| Version | Description |
| 8.1.0 | The connection parameter expects an PgSql\Connection instance now; previously, a resource was expected. |