LXXXI. PostgreSQL functions

Introduction

Requirements

Installation

Runtime Configuration

Taulu 1 .

For further details and definition of the PHP_INI_* constants see ini_set() .

pgsql.allow_persistent boolean

pgsql.max_persistent integer

pgsql.max_links integer



How to use and hints

Varoitus

Taulu 3 .



Esimerkki 1 .




Predefined Constants

These constants are defined by this extension , and will only be available when the extension has either been compiled into PHP or dynamically loaded at runtime .

PGSQL_ASSOC ( integer )

PGSQL_NUM ( integer )

PGSQL_BOTH ( integer )

PGSQL_CONNECTION_BAD ( integer )

PGSQL_CONNECTION_OK ( integer )

PGSQL_SEEK_SET ( integer )

PGSQL_SEEK_CUR ( integer )

PGSQL_SEEK_END ( integer )

PGSQL_ESCAPE_STRING ( integer )

PGSQL_ESCAPE_BYTEA ( integer )

PGSQL_EMPTY_QUERY ( integer )

PGSQL_COMMAND_OK ( integer )

PGSQL_TUPLES_OK ( integer )

PGSQL_COPY_OUT ( integer )

PGSQL_COPY_IN ( integer )

PGSQL_BAD_RESPONSE ( integer )

PGSQL_NONFATAL_ERROR ( integer )

PGSQL_FATAL_ERROR ( integer )

Examples

Esimerkki 2 .




You should not close the connection to the PostgreSQL server before closing the large object.

Sisällys
pg_affected_rows -- Returns number of affected records(tuples)
pg_cancel_query -- Cancel async query
pg_client_encoding -- Get the client encoding
pg_close -- Close a PostgreSQL connection
pg_connect -- Open a PostgreSQL connection
pg_connection_busy -- Get connection is busy or not
pg_connection_reset -- Reset connection (reconnect)
pg_connection_status -- Get connection status
pg_convert -- Convert associative array value into suitable for SQL statement.
pg_copy_from -- Insert records into a table from an array
pg_copy_to -- Copy a table to an array
pg_dbname -- Get the database name
pg_delete -- Delete records.
pg_end_copy -- Sync with PostgreSQL backend
pg_escape_bytea -- Escape binary for bytea type
pg_escape_string -- Escape string for text/char type
pg_fetch_all -- Fetch a row as an array
pg_fetch_array -- Fetch a row as an array
pg_fetch_assoc -- Fetch a row as an array
pg_fetch_object -- Fetch a row as an object
pg_fetch_result -- Returns values from a result resource
pg_fetch_row -- Get a row as an enumerated array
pg_field_is_null -- Test if a field is NULL
pg_field_name -- Returns the name of a field
pg_field_num -- Returns the field number of the named field
pg_field_prtlen -- Returns the printed length
pg_field_size -- Returns the internal storage size of the named field
pg_field_type -- Returns the type name for the corresponding field number
pg_free_result -- Free result memory
pg_get_notify -- Ping database connection
pg_get_pid -- Ping database connection
pg_get_result -- Get asynchronous query result
pg_host -- Returns the host name associated with the connection
pg_insert -- Insert array into table.
pg_last_error -- Get the last error message string of a connection
pg_last_notice -- Returns the last notice message from PostgreSQL server
pg_last_oid -- Returns the last object's oid
pg_lo_close -- Close a large object
pg_lo_create -- Create a large object
pg_lo_export -- Export a large object to file
pg_lo_import -- Import a large object from file
pg_lo_open -- Open a large object
pg_lo_read_all -- Read a entire large object and send straight to browser
pg_lo_read -- Read a large object
pg_lo_seek -- Seeks position of large object
pg_lo_tell -- Returns current position of large object
pg_lo_unlink -- Delete a large object
pg_lo_write -- Write a large object
pg_meta_data -- Get meta data for table.
pg_num_fields -- Returns the number of fields
pg_num_rows -- Returns the number of rows
pg_options -- Get the options associated with the connection
pg_pconnect -- Open a persistent PostgreSQL connection
pg_ping -- Ping database connection
pg_port -- Return the port number associated with the connection
pg_put_line -- Send a NULL-terminated string to PostgreSQL backend
pg_query -- Execute a query
pg_result_error -- Get error message associated with result
pg_result_seek -- Set internal row offset in result resource
pg_result_status -- Get status of query result
pg_select -- Select records.
pg_send_query -- Send asynchronous query
pg_set_client_encoding -- Set the client encoding
pg_trace -- Enable tracing a PostgreSQL connection
pg_tty -- Return the tty name associated with the connection
pg_unescape_bytea -- Escape binary for bytea type
pg_untrace -- Disable tracing of a PostgreSQL connection
pg_update -- Update table.