function db_column_exists

6.x database.pgsql.inc db_column_exists($table, $column)
6.x database.mysqli.inc db_column_exists($table, $column)
6.x database.mysql.inc db_column_exists($table, $column)

Check if a column exists in the given table.

Parameters

$table: The name of the table.

$column: The name of the column.

Return value

TRUE if the column exists, and FALSE if the column does not exist.

Related topics

Database abstraction layer
Allow the use of different database servers using the same code base.
1 call to db_column_exists()
system_update_6051 in drupal-6.x/modules/system/system.install
Create a signature_format column.

File

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

Code

function db_column_exists($table, $column) {
  return (bool) db_result(db_query("SELECT COUNT(pg_attribute.attname) FROM pg_class, pg_attribute WHERE pg_attribute.attrelid = pg_class.oid AND pg_class.relname = '{" . db_escape_table($table) . "}' AND attname = '" . db_escape_table($column) . "'"));
}