Retrieve a table or column comment.

File

includes/database/pgsql/schema.inc, line 814

Class

DatabaseSchema_pgsql

Code

public function getComment($table, $column = NULL) {
 $info = $this->getPrefixInfo ($table);
 // Don't use {} around pg_class, pg_attribute tables.
 if (isset($column)) {
 return $this->connection 
 ->query ('SELECT col_description(oid, attnum) FROM pg_class, pg_attribute WHERE attrelid = oid AND relname = ? AND attname = ?', array(
 $info['table'],
 $column,
 ))
 ->fetchField ();
 }
 else {
 return $this->connection 
 ->query ('SELECT obj_description(oid, ?) FROM pg_class WHERE relname = ?', array(
 'pg_class',
 $info['table'],
 ))
 ->fetchField ();
 }
}

---