database.pgsql.inc

  1. drupal
    1. drupal6

Version 1.68.2.11 (checked in on 2010/12/15 at 20:41:10 by goba)

Database interface code for PostgreSQL database servers.

Funktionen & Methoden

NameBeschreibung
db_add_fieldAdd a new field to a table.
db_add_indexAdd an index.
db_add_primary_keyAdd a primary key.
db_add_unique_keyAdd a unique key.
db_affected_rowsDetermine the number of rows changed by the preceding query.
db_change_fieldChange a field definition.
db_check_setupVerify if the database is set up correctly.
db_column_existsCheck if a column exists in the given table.
db_connectInitialize a database connection.
db_create_table_sqlGenerate SQL to create a new table from a Drupal schema definition.
db_decode_blobReturns text from a Binary Large OBject value. In case of PostgreSQL decodes data after select from bytea field.
db_drop_fieldDrop a field.
db_drop_indexDrop an index.
db_drop_primary_keyDrop the primary key.
db_drop_tableDrop a table.
db_drop_unique_keyDrop a unique key.
db_encode_blobReturns a properly formatted Binary Large OBject value. In case of PostgreSQL encodes data for insert into bytea field.
db_errorDetermine whether the previous query caused an error.
db_escape_stringPrepare user input for use in a database query, preventing SQL injection attacks. Note: This function requires PostgreSQL 7.2 or later.
db_fetch_arrayFetch one result row from the previous query as an array.
db_fetch_objectFetch one result row from the previous query as an object.
db_field_set_defaultSet the default value for a field.
db_field_set_no_defaultSet a field to have no default value.
db_last_insert_idReturns the last insert id. This function is thread safe.
db_lock_tableLock a table. This function automatically starts a transaction.
db_queryRuns a basic query in the active database.
db_query_rangeRuns a limited-range query in the active database.
db_query_temporaryRuns a SELECT query and stores its results in a temporary table.
db_rename_tableRename a table.
db_resultReturn an individual result field from the previous query.
db_status_reportReport database status.
db_table_existsCheck if a table exists.
db_type_mapThis maps a generic data type in combination with its data size to the engine-specific data type.
db_unlock_tablesUnlock all locked tables. This function automatically commits a transaction.
db_versionReturns the version of the database server currently in use.
_db_create_field_sqlCreate 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_fieldSet database-engine specific properties for a field.
_db_queryHelper function for db_query().

Kommentare

Kommentar hinzufügen

Der Inhalt dieses Feldes wird nicht öffentlich zugänglich angezeigt.
  • Internet- und E-Mail-Adressen werden automatisch umgewandelt.
  • Zulässige HTML-Tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Zeilen und Absätze werden automatisch erzeugt.

Weitere Informationen über Formatierungsoptionen

Kommentar hinzufügen

Der Inhalt dieses Feldes wird nicht öffentlich zugänglich angezeigt.
  • Internet- und E-Mail-Adressen werden automatisch umgewandelt.
  • Zulässige HTML-Tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Zeilen und Absätze werden automatisch erzeugt.

Weitere Informationen über Formatierungsoptionen