01createdb.phpt 747 B

12345678910111213141516171819202122232425262728293031323334353637383940
  1. --TEST--
  2. PostgreSQL create db
  3. --SKIPIF--
  4. <?php include("skipif.inc"); ?>
  5. --FILE--
  6. <?php
  7. // create test table
  8. include('config.inc');
  9. $db = pg_connect($conn_str);
  10. if (!@pg_num_rows(@pg_query($db, "SELECT * FROM ".$table_name)))
  11. {
  12. pg_query($db,$table_def); // Create table here
  13. for ($i=0; $i < $num_test_record; $i++) {
  14. pg_query($db,"INSERT INTO ".$table_name." VALUES ($i, 'ABC');");
  15. }
  16. }
  17. else {
  18. echo pg_last_error()."\n";
  19. }
  20. $v = pg_version();
  21. if (version_compare($v['server'], '9.2', '>=') && !@pg_num_rows(@pg_query($db, "SELECT * FROM ".$table_name_92)))
  22. {
  23. pg_query($db,$table_def_92); // Create table here
  24. }
  25. else {
  26. echo pg_last_error()."\n";
  27. }
  28. // Create view here
  29. pg_query($db,$view_def);
  30. pg_close($db);
  31. echo "OK";
  32. ?>
  33. --EXPECT--
  34. OK