4.3. Query Execution Commands

Table of Contents
pg_exec -- send a command to the server
pg_execute -- send a command to the server and optionally loop over the results
pg_select -- loop over the result of a query
pg_exec_params -- Parse and execute a parameterized SQL statement
pg_exec_prepared -- Execute a pre-prepared SQL statement on the server
pg_result -- get information about a command result
pg_escape_string -- Escape a string for use in an SQL string constant
pg_quote -- Escape and quote a string for use in an SQL string constant
pg_escape_bytea -- Escape a binary string for use in an SQL string constant with bytea (byte array) columns
pg_unescape_bytea -- Unescape a string returned by an SQL query on a bytea (byte array) column, recovering the original binary string.

The commands in this section are used to send SQL commands (queries) to the database server, and fetch results from the database server.