Neil Conway wrote:
Denis Vlasenko wrote:
The same php script but done against Oracle does not have this
behaviour.
Perhaps; presumably Oracle is essentially creating a cursor for you
behind the scenes. libpq does not attempt to do this automatically; if
you need a cursor, you can create one by hand.
I do not understand how a cursor could be autocreated by a query like
$result = pg_query($db, "SELECT * FROM big_table");
php will expect $result to contain the entire table (yuck!).
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org