<?php

$connection_string = "host=localhost dbname=vetlearn_programdesinger user=vetlearn_prgdsgn password=prgdsgn";
$new_owner = 'vetlearn';

$conn = pg_pconnect($connection_string);
if (!$conn) {
  echo "An error occured connecting to the database.\n";
  exit;
}

$result = pg_query($conn, "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'");
if (!$result) {
  echo "An error occured finding the list of tables.\n";
  exit;
}

while ($row = pg_fetch_object($result)) {
  $table_name = $row->table_name;
  echo "Altering table $table_name\n";
  pg_query("ALTER TABLE $table_name OWNER TO $new_owner") ;
}