Skip site navigation (1) Skip section navigation (2)

Re: large resultset

From: Thom Brown <thombrown(at)gmail(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: large resultset
Date: 2010-06-15 09:33:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-php
On 15 June 2010 09:31, AI Rumman <rummandba(at)gmail(dot)com> wrote:

> How to return large resutlset (almost 2 millions record) in php?

Presumably this is so people can download results rather than display them
in a browser?

Here's a basic a raw version of what you can do:

$db = pg_connect($connection_string);

$results = pg_query($db, $query);

while ($result = pg_fetch_array($results)
    echo implode("|", $result) . "\n";


Obviously that wouldn't do by itself, but it's quite simple to loop over a
result set.



In response to


pgsql-php by date

Next:From: vinnyDate: 2010-06-15 09:40:11
Subject: Re: large resultset
Previous:From: AI RummanDate: 2010-06-15 08:31:32
Subject: large resultset

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group