postgresql query

[wxdqz]

Why doesn't this work?

<?php
$database = pg_connect ("dbname=sam.db");
$izpis = pg_exec ($database, "SELECT * FROM test");
print "$izpis";

if (!$database) die("something's gone horribly wrong.");
else print "<P>Connect successful</P>";

pg_ErrorMessage();
pg_close()
?>

All i get is:

Resource id #2

Connect successful


Please Help!

Thanks