pg_exec

(PHP 3 <= 3.0.18, PHP 4 >= 4.0.0)

pg_exec -- Execute a query

Description

resource pg_exec (resource connection, string query)

pg_exec() returns a query result resource if query could be executed. It returns FALSE on failure or if connection is not a valid connection. Details about the error can be retrieved using the pg_errormessage() function if connection is valid. pg_errormessage() sends an SQL statement to the PostgreSQL database specified by the connection resource. The connection must be a valid connection that was returned by pg_connect() or pg_pconnect(). The return value of this function is an query result resource to be used to access the results from other PostgreSQL functions such as pg_fetch_array().

Note: connection is a optional parameter for pg_exec(). If connection is not used, default connection is used. Default connection is the last connection made by pg_connect() or pg_pconnect().

Although connection can be omitted, it is not recommended, since it could be a cause of hard to find bug in script.

See also pg_connect(), pg_pconnect(), pg_fetch_array(), pg_fetch_object(), pg_numrows(), and pg_cmdtuples().