Contents /
Previous /
Next
PHP PostgreSQL DB Functions: Overview
- 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.