function _db_create_index_sql

6.x database.pgsql.inc _db_create_index_sql($table, $name, $fields)

Related topics

Schema API
A Drupal schema definition is an array structure representing one or more tables and their related keys and indexes. A schema is defined by hook_schema(), which usually lives in a modulename.install file.
2 calls to _db_create_index_sql()
db_add_index in drupal-6.x/includes/database.pgsql.inc
Add an index.
db_create_table_sql in drupal-6.x/includes/database.pgsql.inc
Generate SQL to create a new table from a Drupal schema definition.

File

drupal-6.x/includes/database.pgsql.inc, line 522
Database interface code for PostgreSQL database servers.

Code

function _db_create_index_sql($table, $name, $fields) {
  $query = 'CREATE INDEX {' . $table . '}_' . $name . '_idx ON {' . $table . '} (';
  $query .= _db_create_key_sql($fields) . ')';
  return $query;
}