Home > PHP > Function > PostgreSQL > pg_insert()

pg_insert()

pg_insert - Insert array into table

Syntax

mixed pg_insert (resource $connection, string $table_name, array $assoc_array, int $options)

Arguments

  • connection - PostgreSQL database connection resource.
  • table_name - Name of the table into which to insert rows. The table table_name must at least have as many columns as assoc_array has elements.
  • assoc_array - An array whose keys are field names in the table table_name, and whose values are the values of those fields that are to be inserted.
  • options - Any number of PGSQL_CONV_OPTS, PGSQL_DML_NO_CONV, PGSQL_DML_EXEC, PGSQL_DML_ASYNC or PGSQL_DML_STRING combined. If PGSQL_DML_STRING is part of the options then query string is returned.

Description

pg_insert() inserts the values of assoc_array into the table specified by table_name. If options is specified, pg_convert() is applied to assoc_array with the specified options.

Version

PHP 4.3.0, 5

Return value

Returns TRUE on success or FALSE on failure. Returns string if PGSQL_DML_STRING is passed via options.