database.pgsql.inc

• Drupal 4.6
• Drupal 4.7
• Drupal 5
• Drupal 6

• View documentation
• View source

Version

1.29.2.4 (checked in on 2006/11/15 at 21:51:38 by killes)

Description

Database interface code for PostgreSQL database servers.

Functions

Name	Description
db_affected_rows	Determine the number of rows changed by the preceding query.
db_check_setup	Verify if the database is set up correctly.
db_connect	Initialize a database connection.
db_decode_blob	Returns text from a Binary Large OBject value. In case of PostgreSQL decodes data after select from bytea field.
db_distinct_field	Wraps the given table.field entry with a DISTINCT(). The wrapper is added to the SELECT list entry of the given query and the resulting query is returned. This function only applies the wrapper if a DISTINCT doesn't already exist in the query.
db_encode_blob	Returns a properly formatted Binary Large OBject value. In case of PostgreSQL encodes data for insert into bytea field.
db_error	Determine whether the previous query caused an error.
db_escape_string	Prepare user input for use in a database query, preventing SQL injection attacks. Note: This function requires PostgreSQL 7.2 or later.
db_fetch_array	Fetch one result row from the previous query as an array.
db_fetch_object	Fetch one result row from the previous query as an object.
db_lock_table	Lock a table. This function automatically starts a transaction.
db_next_id	Return a new unique ID in the given sequence.
db_num_rows	Determine how many result rows were found by the preceding query.
db_query_range	Runs a limited-range query in the active database.
db_query_temporary	Runs a SELECT query and stores its results in a temporary table.
db_result	Return an individual result field from the previous query.
db_unlock_tables	Unlock all locked tables. This function automatically commits a transaction.
_db_query	Helper function for db_query().