pg_select_query1.htm

Super user: Super user can query any table, and owner of the table can only query the table created by the owner. The highlighted user can connect to db and a table birthdays, but can't access the table emp, created by a super user.

<?php
echo "debug OK :pg_select_query1.php<br/>";
//$dbconn= pg_connect("dbname=postgres") or die("Could not connect");
$dbconn= pg_connect("host=localhost dbname=pgsdemo1 user=postgres password=postgre_manas9")
or die("Can't connect to database".pg_last_error());
// $dbconn= pg_connect("host=localhost dbname=pgsdemo1 user=manas237 password=pwmanas237") or die("Can't connect to database".pg_last_error());
echo " db connected <br/>";
$sql ="SELECT * FROM EMP";
$result = pg_query($dbconn, $sql);
echo " Select Query to emp table -passed <br/>";
//
pg_close($dbconn);
echo" db:: closed with pg_close() function <br/>";
?>