Dealing with DDLs

In PHP, we have the pg_query() function that we use to execute all kinds of SQL statement. We can use this function to execute either DDL or DML statements. This function takes two arguments; one is the db connection resource and the other is an SQL statement. To track the SQL statement status, we have the pg_last_error() function, which takes the db connection as its argument.

Now, let's try to create a test table using the preceding getDBConnection()

<?php 
include'pgconnection.php'; 
 
$con=getDBConnection(); 
$sql =<<<EOF 
CREATE TABLE test(d char(1)); 
EOF; 
 
if (pg_query($con, $sql)) { 
  echo"test table is created successfully\n"; 
} 
else{ 
  echo"Failed in creating table\n"; 
  echopg_last_error($con); 
  echo"\n"; 
} 
?> 
 
$ phptest.php 
Successfully made connection to PostgreSQL 
pg connection pid is 91659 
test table is created successfully...