Re: Calling Stored Procedures from PHP

On Mar 29, 2005, at 3:48 PM, Cima wrote:

>
> how do i call a stored procedure i have in postgresql 8.0.1 from  php 
> with the necesary parameters or variables?


You don't say want php interface you are using, but with the standard 
pgsql interface included with php it might look something like this:

$x = 3;
$result = pg_query($conn, "select myprocedure(1, 2, $x);");
$rows = pg_fetch_all($result);


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL