php-postgresql在插入之前检查记录是否已经存在

我无法找出查询语句的正确措辞/语法。我想检查一下我们的表中是否已经有一所学校（命名学校）与学校名称匹配。如果是，则表示该状态已存在。任何投入都会很棒！

  //create a connection (the connection is made in another php file)
  $obj = new MyConnection();
  $obj->setConn();
  $obj->displayValues();
  $qObj = new MyCode();
  $qObj->setConn( $obj->getConn());
  //Query to put all the school data into db
  $q1 = "INSERT INTO schools(
                 SchoolName,
                 SchoolWebsite,
                 City,
                 State,
                 Locale,
                 Sector,
                 Tuition,
                 GradRate,
                 FacToStudRatio,
                 StudentPop,
                 FreshmenPop,
                 PercentWomen,
                 PercentMen,
                 PercentAdmitted,
                 AverageGpa,
                 AverageScore)
        VALUES ('$SchoolName',
                '$SchoolWebsite',
                '$City',
                '$State',
                '$Locale',
                '$Sector',
                '$Tuition',
                '$GradRate',
                '$FacToStudRatio',
                '$StudentPop',
                '$FreshmenPop',
                '$PercentWomen',
                '$PercentMen',
                '$PercentAdmitted',
                '$AverageGpa',
                '$AverageScore')";

  $findResult = pg_query( 'SELECT * FROM schools WHERE schoolname =.$SchoolName);
  if ($findResult != 0) 
  {
    echo "School Record Already Exists<br/>";
    die;
  }
  $qObj->setQuery($q1);
  $qObj->runQuery();