Check that any given schema exists.

Parameters

$schema: The name of the schema to check the existence of

Return value

TRUE/FALSE depending upon whether or not the schema exists

Related topics

File

tripal_chado/api/tripal_chado.schema.api.inc, line 258

Provides an application programming interface (API) for describing Chado tables.

Code

function chado_dbschema_exists($schema) {

  $sql = "
    SELECT nspname
    FROM pg_namespace
    WHERE
      has_schema_privilege(nspname, 'USAGE') AND
      nspname = :nspname
    ORDER BY nspname
  ";
  $schema = db_query($sql, array(':nspname' => $schema))->fetchField();
  if ($schema) {
    return TRUE;
  }
  return FALSE;
}