<?php

$host = "localhost";
$user = "postgres";
$pass = "******";
$db = "user_info";

$con = pg_connect("host=$host dbname=$db user=$user password=$pass") or die("Couldnt connect to server\n");

$query = "SELECT id,name,price FROM test ";

$rs = pg_query($con, $query) or die ("Couldnt execute query: $query\n");

while ($ro = pg_fetch_object($rs)){
    echo $ro->id ." ";
    echo $ro->name." ";
    echo $ro->price." ";
    echo "\n";


}

pg_close($con);

?>