Creating PostgreSQL stored function and calling the same using PHP script.
The query tool, pgAdmin3.exe of PostgreSQL is a fantastic query tool. Unlike PL-SQL, the function created with SQL-Query tool, will help to create a SQL query.

The SQL Developer  tool for oracle creates PL/SQL Block with codes to call the custom functions.


How to Query stored function with PHP :

//PostgreSQL SQL query script:

$sql="SELECT round (cfcal($celcius),2)";
$result = pg_query($dbconn,$sql);

//Oracle stored function for the similar code

$stid = oci_parse($conn, "begin :bv:=CTOF(29.25); end;");
echo "uses oci_bind_name </br/>";
oci_bind_by_name($stid, ":bv", $p1, 6);


Workstation: manas9 : windows 8

pwd: postgre_manas9

Now open a query pane

Opens a sql query window

Now add any value you want

Use this script with PHP

class StringClass
public $var1;public $num =0;

public function __construct($param1)
$this->var1 = $param1;
//echo "object constructed ";
public function __destruct()

// echo "<br/>object destructed";

public function __toString()
return $this->var1;

<html lang="en">
<meta charset="utf-8">
<meta name="description" >

$str1= "<br/>Callling Stored function with php <br/>" ;
$class1= new StringClass($str1);
echo $class1;

//$class = new StringClass('Hello');
//echo $class;
$host = "localhost";
$user = "manas237";
$pass = "pwmanas237";
$db = "pgsdemo1";
$celcius = 29.25;
// open a connection to the database server
$dbconn = pg_connect ("host=$host dbname=$db user=$user password=$pass");
echo "Error : Unable to open database\n";
} else {
echo "Opened database successfully<br/>";
$sql="SELECT round (cfcal($celcius),2)";
$result = pg_query($dbconn,$sql);
echo pg_last_error($db);
$class2 = new StringClass($sql);
echo "<br/> query string ". $class2;
echo "<br/>Temp : ".$celcius. "<sup>0</sup>C =". pg_fetch_result($result,0)."<sup>0</sup> F";