Contributions API

database.pgsql.inc

Version

1.68.2.2 (checked in on 2008/07/08 at 09:50:03 by goba)

Description

Database interface code for PostgreSQL database servers.

Functions

Name	Description
db_add_field	Add a new field to a table.
db_add_index	Add an index.
db_add_primary_key	Add a primary key.
db_add_unique_key	Add a unique key.
db_affected_rows	Determine the number of rows changed by the preceding query.
db_change_field	Change a field definition.
db_check_setup	Verify if the database is set up correctly.
db_column_exists	Check if a column exists in the given table.
db_connect	Initialize a database connection.
db_create_table_sql	Generate SQL to create a new table from a Drupal schema definition.
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_drop_field	Drop a field.
db_drop_index	Drop an index.
db_drop_primary_key	Drop the primary key.
db_drop_table	Drop a table.
db_drop_unique_key	Drop a unique key.
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_field_set_default	Set the default value for a field.
db_field_set_no_default	Set a field to have no default value.
db_last_insert_id	Returns the last insert id. This function is thread safe.
db_lock_table	Lock a table. This function automatically starts a transaction.
db_query	Runs a basic query in the active database.
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_rename_table	Rename a table.
db_result	Return an individual result field from the previous query.
db_status_report	Report database status.
db_table_exists	Check if a table exists.
db_type_map	This maps a generic data type in combination with its data size to the engine-specific data type.
db_unlock_tables	Unlock all locked tables. This function automatically commits a transaction.
db_version	Returns the version of the database server currently in use.
_db_create_field_sql	Create an SQL string for a field to be used in table creation or alteration.
_db_create_index_sql
_db_create_keys
_db_create_key_sql
_db_process_field	Set database-engine specific properties for a field.
_db_query	Helper function for db_query().